Try this:

Delete all of the extraneous rows and columns.
(EditDeleteEntire Row/Column)

Save the workbook.

Try [Ctrl]+[End]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"DAVIS" wrote:

How do you change the last cell in your worksheet? I want to reassign the
last cell it takes me to when I choose CTRL+END.