CTRL + Down goes to cell above first empty cell in the column, not necessarily
to last used row.

See other responses for getting true last row and giving it a numbered value.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 19:05:42 -0500, "Solon" wrote:

The guy who gave me the macro said he'd never considered doing a "Ctrl+Down"
to simply go to the last used row, then do his search from there,