jason,

Without having to always remember the row number 65536
Eventually, you cross a threshold where you never have to
"remember" it. It'll be permanently burned into your memory
and from that point on you'll never be able to forget it.

Aside from that, Chip's answers work very well.

John

"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