Set Range Color for all sheet

[myName]

Hello,
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.

[KarthikByggari]

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

[myName]

It unfortunately, does not work

[KarthikByggari]

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

[myName]

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

[KarthikByggari]

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.

[myName]

Thank you very much, it works!