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