sheets("Sheet1").range("A65535").end(xlUp).select

This code selects the last populated cell in column A on sheet 1. There are
a bunch of variations of this code which all do the same thing.

HTH

"John Spiegel" wrote:

Hi all,

How does one find the last row, column or cell in a sheet or range? I'm
currently working with automating Excel 2000.

TIA,

John