dynamic selection of cells

[parthaemail]

hi
The below code shows an error in the second line . if give sheet1.Range("C10").select its working fine but i want to populate the i value from C1 to C100 cells.

For i = 1To 110 Step 1
Sheet1.Range(C(i)).Select
varnbrows = Selection.CurrentRegion.Rows.count
Selection.Value = i
Next i

thanks in advance

[Bob Phillips]

Sheet1.Range("C" & i).Select


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"parthaemail" <[email protected]>
wrote in message
news:[email protected]...
>
> hi
> The below code shows an error in the second line . if give
> sheet1.Range("C10").select its working fine but i want to populate the
> i value from C1 to C100 cells.
>
> For i = 1To 110 Step 1
> Sheet1.Range(C(i)).Select
> varnbrows = Selection.CurrentRegion.Rows.count
> Selection.Value = i
> Next i
>
> thanks in advance
>
>
> --
> parthaemail
> ------------------------------------------------------------------------
> parthaemail's Profile:
http://www.excelforum.com/member.php...o&userid=31311
> View this thread: http://www.excelforum.com/showthread...hreadid=535899
>