Fill property
 

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?

Fill property
 

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?

Fill property
 

Thanks,

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

"Tom Ogilvy" wrote:

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?