I need to get the row number of my last row in a selection dynamically

How do I get this?


Thanks

--
Message posted from http://www.ExcelForum.com

Hi
if you want the last row in your current selection try
sub foo()
dim rng as range
dim lastrow as long
set rng = selection
lastrow = rng.row+rng.rows.count-1
msgbox lastrow
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


I need to get the row number of my last row in a selection
dynamically

How do I get this?


Thanks!


---
Message posted from http://www.ExcelForum.com/

if rTarget is your range, then
rTarget.Row is the first row,
rTarget.Rows.Count is the number of rows,
thus then last row is
with rTarget
lastrow = .Row + .Rows.Count -1
end with

Patrick Molloy
Microsoft Excel MVP
------------------
I feel Great!

-----Original Message-----
I need to get the row number of my last row in a
selection dynamically

How do I get this?


Thanks!


---
Message posted from http://www.ExcelForum.com/

.

selection.rows(selection.rows.count).row

--
Regards,
Tom Ogilvy

"andycharger " wrote in message
...
I need to get the row number of my last row in a selection dynamically

How do I get this?


Thanks!


---
Message posted from http://www.ExcelForum.com/

MsgBox Selection.Rows.Count + Selection.Row - 1

Just in case you are looking for the last row of your selection on your workbook.


Regards Robert

"andycharger " wrote in message ...
I need to get the row number of my last row in a selection dynamically

How do I get this?


Thanks!


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 09/04/2004