Set Range Color for all sheet

I want to clear all colors from excel sheet(so every cell will be white), before i will write data here. Do you have any idea, how could I set “Range” in Set range color activity?

Thank you very much for your reply. :slight_smile:

For the entire range, you can simply give two double quotes - “”

It unfortunately, does not work :frowning:

Can you please just leave the Range empty (remove even quotes) and try.

It writes, that value for required activity argument Range is not supplied.

which excel version you are using?
If >= Excel 2016, you can hard code the Range
Range = "A1:XFD1048576"
It will set the entire sheet color.

1 Like

Thank you very much, it works!

1 Like