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

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

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