Jason,

Try

Cells(Rows.Count, "A").End(xlUp).Select
'or
ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Select

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"jason" wrote in message
om...
Without having to always remember the row number 65536 how do I
quickly reference the last row in a worksheet.This has to work even if
there is a load of tables all over the sheet i.e [A1].end(xldown) will
not work!

Cheers
Jason