it depends on your sheet / data list layout - where is the list??
Activesheet.Cells.SpecialCells(xlCellTypeLastCell) .Row
is my favorite for the last used row on a sheet.


"narutard" wrote:


super simple q

i want to save the row number at the end of the list of the data. what
is the command for that?

i can't use selection.rows.count because its not a selection of
multiple rows..


thanks


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=467858