Coluring cells in a Range

[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.

 

[Nigel]

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

 

[Stuart]

Many thanks.
It was a typo error of mine in the troublesome code.

Regards.