row location
 

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

row location
 

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

row location
 

i 'm looking for

1 a
2 b
3 c
4 d
5 e
6 f
...
485 zzzz


so...i want the command that figures out which row zzzz is


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

row location
 

Hi Narutard,

Try:

Dim rw As Long

rw = Cells(Rows.Count, "A").End(xlUp).Row

---
Regards,
Norman



"narutard" wrote in
message ...

i 'm looking for

1 a
2 b
3 c
4 d
5 e
6 f
..
485 zzzz


so...i want the command that figures out which row zzzz is


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