Worksheet backcolor within range
 

I am using VBA to create a new worksheet and then copy over some values.
However, I need to make the background all white so as to not show the lines
between cells. I need to do this via VBA as it has to be an automated process.

Worksheet backcolor within range
 

Hi Stanly

You can use
ActiveWindow.DisplayGridlines = False



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stanley" wrote in message ...
I am using VBA to create a new worksheet and then copy over some values.
However, I need to make the background all white so as to not show the lines
between cells. I need to do this via VBA as it has to be an automated process.

Worksheet backcolor within range
 

For a range you can use this

Range("A1:B20").Interior.ColorIndex = 2


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi Stanly

You can use
ActiveWindow.DisplayGridlines = False



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stanley" wrote in message ...
I am using VBA to create a new worksheet and then copy over some values.
However, I need to make the background all white so as to not show the lines
between cells. I need to do this via VBA as it has to be an automated process.