J
JVLennox
Hi everybody!
I am trying to automatically insert an empty cell between colore
cells!
--> Each time I have a blue colored cell followed by a red colored cel
in column A, I want an empty cell to be inserted between these cells.
I tried to work something out, but all I can offer is this, whic
determines the color. How do I get Excel to insert the cells throughou
the whole column A???
THANKS FOR ANY HELP!!!!
JVLennox
Range("????").Select
With Selection.Interior
.ColorIndex = 5
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Range("????").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End Wit
I am trying to automatically insert an empty cell between colore
cells!
--> Each time I have a blue colored cell followed by a red colored cel
in column A, I want an empty cell to be inserted between these cells.
I tried to work something out, but all I can offer is this, whic
determines the color. How do I get Excel to insert the cells throughou
the whole column A???
THANKS FOR ANY HELP!!!!
JVLennox
Range("????").Select
With Selection.Interior
.ColorIndex = 5
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Range("????").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End Wit