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/

.