Re: Reset conditional color VB
- From: "Trevor Shuttleworth" <Trevor@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2007 19:03:45 +0100
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" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:55C2DBB9-D051-49B8-930B-CA07C9EA758B@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Macro to copy data
- Next by Date: Re: How to terminate an object that's in a collection
- Previous by thread: Macro to copy data
- Next by thread: VBA to find the bottom of a ***
- Index(es):
