Can "target.row" be used to select a range of cells instead of just one?

[bovinda]

I have a script that changes font color in a bunch of cells (~30) in the same row. Right now, I'm having to enter

Me.Cells(Target.Row, "C").Font.ColorIndex = myColor
Me.Cells(Target.Row, "E").Font.ColorIndex = myColor
Me.Cells(Target.Row, "F").Font.ColorIndex = myColor
Me.Cells(Target.Row, "G").Font.ColorIndex = myColor
Me.Cells(Target.Row, "H").Font.ColorIndex = myColor...

...etc., etc. for each cell I want affected. Is there a way to specify a range of cells? Like this:

Me.Cells(Target.Row, "C-H").Font.ColorIndex = myColor

So that cells C through H are affected by the change? It would save a lot of typing and cut and pasting!

Thanks for any and all suggestions!

 

[RoryA]

Me.Cells(Target.Row, "C").Resize(,6).Font.ColorIndex = myColor

should do it.

 

[bovinda]

See, that's what makes the intarweb awesome, because I never would have figured that out in a million years on my own! That's exactly what I was looking for. Thanks Rory!