Set Range Color - No Fill

Help
1

Hi

How do i set range color in excel to No Fill? I have Tried Color.Empty but it just makes the selected range black.

Thanks

2

I’d suggest to use Color.White, as this is same color you’ll get from get color from empty cell but it will lose the grid lines.
Another solution I can think of is to create a macro to clear fill, and use Execute Macro activities by calling the macro name.

Regards,
Ajeed Rahman

3

Are there any better solutions to this issue? It seems very inconvenient to not have the option to simply “no fill” a cell instead of being forced to fill a color, even if white.