nevermind i got it

Range(("C" & 24 * i + 2), ("C" & 24 * i + 25)).Select

thanx

"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