clear pattern not gridlines
 

the statement cells.Interior.ColorIndex = xlNone
will clear a color pattern but does not seem to work on one that was set
using the ISBLANK statment in an earlier sheet. using format/cells also does
not clear the pattern. do i need to delete sheet contents to erase a color
pattern

thanks

clear pattern not gridlines
 

Try

Cells.FormatConditions.Delete

If this is not it I will have to pass on trying to assist you further


---
Message posted from http://www.ExcelForum.com/

clear pattern not gridlines
 

that did the trick
thanks
"mudraker " wrote in message
...
Try

Cells.FormatConditions.Delete

If this is not it I will have to pass on trying to assist you further


---
Message posted from http://www.ExcelForum.com/