Reset conditional color VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top