trying to find last row

J

Jase

I am doing a search for the last row with data in my sheet using :
"Cells.SpecialCells(xlCellTypeLastCell).Row"
and i only have data going to row 142 but it tells me that the last row
with data is 345. Any ideas?

thanks,

Jase
 
R

Rick Rothstein

I use this to find the last "in use" cell on the worksheet (change
ActiveSheet to a specific worksheet name if your code is not working on the
active sheet)...

LastUsedRow = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlRows, _
SearchDirection:=xlPrevious).Row
 

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
auto scale print area 3
Find last row with hidden rows 2
Excel Help to copy information from one row at a time to another sheet 1
Macro: Delete Row Above Last 3
Hide Column If Usedrange of Column ISBLANK Follow-up 1
Copy and paste up to values in last row 2
Last row is empty 2

Top