loop syntax
 

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

loop syntax
 

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

loop syntax
 

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