Clearing Interior Color Of Cell

mms
05-15-2008, 11:34 AM
I am trying to remove the coloring in a range of cells programatically.


Cells(FirstRow, 2).Resize(NumRows, 8).Interior.Color = xlNonecauses cells in selected range to turn a light blue.

Is there another constant I should be using?

Colin Legg
05-15-2008, 11:37 AM
You're close, mms.... try the same but with the colorindex property instead of the color property... ;)

HTH

Colin

mms
05-15-2008, 11:56 AM
That did it...

Thank you!! :D

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum