| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset conditional color VB
Hi
I used VBA to conditional color bar chart but when I run macro again it paint on top of last coloring task. How can I reset the function Interior.ColorIndex= .... to begin color my bar chart in fresh condition? Thanks Daniel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reset conditional color VB
Daniel
maybe: Selection.Interior.ColorIndex = xlNone For example: With Selection.Interior .ColorIndex = 6 ' set the colour to yellow .Pattern = xlSolid End With Selection.Interior.ColorIndex = xlNone ' reset the colour Or, if you want to change a specific cell: Range("A1").Interior.ColorIndex = xlNone Regards Trevor "Daniel" wrote in message ... Hi I used VBA to conditional color bar chart but when I run macro again it paint on top of last coloring task. How can I reset the function Interior.ColorIndex= .... to begin color my bar chart in fresh condition? Thanks Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reset every other row color after sorting | Excel Discussion (Misc queries) | |||
| Reset Color Palette | Excel Discussion (Misc queries) | |||
| My Color Palette Reduced to 13 and will not Reset | Excel Discussion (Misc queries) | |||
| How to reset color palette | Excel Discussion (Misc queries) | |||
| How do I reset my color palette in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
