John Walkenbach has written a function to locate the last cell of a column.
Check out this website.

http://j-walk.com/ss/excel/tips/tip30.htm




"Michael" ?????
...

Hi all,

Is it possible to create a macro that will automatically
go to the last used or manually altered cell in a
worksheet.?

Thanks for your help

Michael