Thread: NoFill range of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
  
Posts: 296
Default NoFill range of cells
On 12 Aug 2005 11:36:17 -0700, wrote:

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" ?


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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Reply With QuoteReply With Quote