Sure, use the correct constant which is xlNone or xlColorIndexNone

This is spelled out pretty clearly in the help for the colorindex property:

For interior:
Set this property to xlColorIndexNone to specify that you don't want an
interior fill.

--
Regards,
Tom Ogilvy


"chick-racer" wrote in message
...

actually on further testing, the second line is the problem.
This was only supposed to change the cells with colored background back
to origional default.. Instead it eliminates the grey default gridlines
that excel has (which dont print)
I would like to have those visible, is there a way to erase the
interior color of the cells and not eliminate the grey gridlines?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/