Select row 65536 in the column of interest and then control-up. You can
record this and then look at the VBA:
Range("I65536").Select
Selection.End(xlUp).Select
--Bruce

"aftamath" wrote:

How do I use VBA code to lookup the last entry in a column.