Thread: NoFill range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] miasmal@gmail.com is offline
external usenet poster
  
Posts: 5
Default NoFill range of cells
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" ?

Reply With QuoteReply With Quote