Fill property

[sip8316]

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

--
Regards,
Tom Ogilvy

"sip8316" <[email protected]> wrote in message
news:[email protected]...
> 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?

[sip8316]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>