trying to find last row

[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

 

[Ron de Bruin]

Hi Jase

See
http://www.rondebruin.nl/last.htm

 

[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