Row number of last cell with data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.

I'm trying to find the code for obtaining the row number of the last cell
with data in a spreadsheet. This is probably an easy one. I don't see any
posts jumping out at me about it though.
 
Sub Test()
lRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
MsgBox lRow
End Sub
 
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

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
Count latest number of continous not-empty cells in a row. 11
Column number of last column that returns value ignore formulas 8
Getting Last Non-Blank Row Number With VBA 2
i = row number of last occurance of duplicate string Column A 4
Identify Last Cell and autofill last column 4
adding lines of code to a macro to delete rows 11

Back
Top