is it possible to write set color to range to read to my what ever selected last row?
instead of the whole column like this ?
Hi @CoolRobot ,
In that case get the last row and give the address of that row only like “E429222:N42922”
Not how to get last row.
You can get it from datatable.row.count or you can also use below code to get last row.
GetLastRow.xaml (7.3 KB)
i created already a last row variable
but color range i cant set it to a last row variable
the error keep telling me range does not exist
i do not want it to read E429222:N42922 as this row are not static
they are usually moving around different daily row
ok thanks i think i know what i should do already
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.