Range("A1:B10").Interior.ColorIndex = xlNone

Always worth recording a macro - make the change then undo the change then
take a look at the code.

--
Cheers
Nigel



wrote in message
oups.com...
Hi,

How do I clear the color/shading of cells?

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

..will make it white but I lose the gridlines. How do I incorporate
the statement "Cells.ColorIndex = xlColorIndexNone" ?