In article ,
says...
and the limitations of End(xlUP) and End(xlDown) are ...?


Many, Bob. Depending on your intent, the results may surprise you.
Even for finding the last cell with data in a column, say, i,
Cells(rows.count,i).end(xlup) is flawed!

Try the End() properties (methods?) with
a completely empty column
a completely full column,
a partially filled column with data starting at the top,
a partially filled column with data starting at the bottom, and
a partially filled column with empty cells at the top and the bottom,
a partially filled column with multiple blocks of data separated by
empty cells.

And, in the context of this discussion, as a tool for finding the last
used cell, which row/column would one check?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions