dynamic selection of cells
 

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

dynamic selection of cells
 

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"parthaemail"
wrote in message
...

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