since you didn't show your line of code, here is a general example:

ActiveCell.Interior.ColorIndex = xlNone

--
Regards,
Tom Ogilvy

"sip8316" wrote in message
...
I am using this line of code to change the Fill color of a cell, it works
fine but what code can I use to set it back to NO FILL do to certain
circumstances?