Fill property

[Guest]

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?

 

[Tom Ogilvy]

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

ActiveCell.Interior.ColorIndex = xlNone

 

[Guest]

Thanks,

That did it, and sorry I thought I pasted and copied