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