c is a range and want to use within a cells range

[keith05281967]

Greetings,

I have the following piece of code:

For i = 2 To lastrow
....If Cells(i, ColumnNumber).Value >= 0.55 Then
........Cells(i, c).Interior.ColorIndex = 4
........intCounter5 = intCounter5 + 1
....End If
Next i

the "c" is a range value that is used earlier in the code to identify a specific column header. I now want to refer to that column and hi-lite cells within that column in green if it meets a certain criteria. But i'm getting "type mis-match" error.

How do i use a Range w/in a range?

Excel 2007,
thanks

 

[Norie]

If you want to use the column of the cell then it's just c.Column:

Cells(i, c.Column).Interior.ColorIndex = 4

 

[keith05281967]

Yes, that is exactly what I was looking for. Thank you Norie.

Keith