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/