Maybe:

Range("C" & 24 * i + 2 & ":C" & 24 * i + 25).Select
Or
Cells(24 * i + 2, "C").Resize(24, 1).Select
or
Range("C" & 24 * i + 2).Resize(24, 1).Select

I like the middle one!


Knox wrote:

can someone correct the syntax in the last line below. Thank you

I just want C(24*i+2):C(24*i+25) to be selected. thanx

Dim i As Long
For i = 1 To 1
Range("C" & 24 * i + 2:"C" & 24 * i + 25).Select

--

Dave Peterson