Coluring cells in a Range

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

..Range("J6").Interior.ColorIndex = 2 works
..Range("J6:J8").Interior.ColorIndex = 2 does not

If I say
For Each c In .Range("J6:J8")
then it will work.

Do I Really have to do this cell by cell, please?

Regards.
 
Both should work - why do you have a period in front of the range? Is there
a control structure around this instructions With-EndWith or something else?
This might be a causal factor. Try the command simply as
Range("J6:J8").Interior.ColorIndex = 2
if that works progress from there to the next level.

Cheers
Nigel
 
Back
Top