Worksheet backcolor within range

[Stanley]

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.

[Ron de Bruin]

Hi Stanly

You can use
ActiveWindow.DisplayGridlines = False



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


"Stanley" <Stanley@discussions.microsoft.com> wrote in message news:7167C387-9A48-4784-B0DD-E067242B6226@microsoft.com...
>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.

[Ron de Bruin]

For a range you can use this

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


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


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:eV2edZfIGHA.1312@TK2MSFTNGP09.phx.gbl...
> Hi Stanly
>
> You can use
> ActiveWindow.DisplayGridlines = False
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Stanley" <Stanley@discussions.microsoft.com> wrote in message news:7167C387-9A48-4784-B0DD-E067242B6226@microsoft.com...
>>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.
>
>