Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change the number of rows to a variable
You could create a macro that when activated gives you the number of rows. Dim i as integer i = 0 Do until ActiveCell = "" ActiveCell.Offset(1,0).Select i = i +1 Loop 'At this point choose any cell that you want that value to be returned to 'for example Range("D1").Value = i I hope that this helps. theguz -- theguz ------------------------------------------------------------------------ theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918 View this thread: http://www.excelforum.com/showthread...hreadid=395920 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy down with variable number of rows | Excel Discussion (Misc queries) | |||
Linking to a Variable Number of Rows - XP/07 | Excel Worksheet Functions | |||
Paste to variable number of rows | Excel Programming | |||
Paste to variable number of rows | Excel Programming | |||
deleting variable number of rows | Excel Programming |