Color range to last row


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 ?

1 Like

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)

1 Like


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.