software

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.

Hi Stanly

You can use
ActiveWindow.DisplayGridlines = False
--
Regards Ron de Bruin
www.rondebruin.nlquot;Stanleyquot; gt; wrote in message ...
gt;I am using VBA to create a new worksheet and then copy over some values.
gt; However, I need to make the background all white so as to not show the lines
gt; between cells. I need to do this via VBA as it has to be an automated process.
For a range you can use this

Range(quot;A1:B20quot;).Interior.ColorIndex = 2--
Regards Ron de Bruin
www.rondebruin.nlquot;Ron de Bruinquot; gt; wrote in message ...
gt; Hi Stanly
gt;
gt; You can use
gt; ActiveWindow.DisplayGridlines = False
gt;
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Stanleyquot; gt; wrote in message ...
gt;gt;I am using VBA to create a new worksheet and then copy over some values.
gt;gt; However, I need to make the background all white so as to not show the lines
gt;gt; between cells. I need to do this via VBA as it has to be an automated process.
gt;
gt;