| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the alternative for PlotArea.Fill. Fill property is hidden | New Users to Excel | |||
| Value Property vs Text property | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
| Is there a Filename property in PrintOut property | Excel Programming | |||
| List Fill Range Property | Excel Programming | |||
Linear Mode
