Getting a row number of the last row?

  • Thread starter Thread starter andycharger
  • Start date Start date
A

andycharger

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

How do I get this?


Thanks
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count latest number of continous not-empty cells in a row. 11
Paste in column B using Last row of either column B, C or D. 10
Getting Last Non-Blank Row Number With VBA 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Return last row no. of column with blanks at top 7
Column number of last column that returns value ignore formulas 8
End process at last row of data 3
i = row number of last occurance of duplicate string Column A 4

Back
Top