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

--
Rick (MVP - Excel)


"Jase" wrote in message
...
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