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]...