So in Excel, on that sheet, if you press F5 on the keyboard, click the Special… button and double-click the last cell option, it takes you to a different place?


A keyboard shortcut can be set up in Excel; see if you have the likes of:
application.onkey "^{END}","a macro name here"
anywhere in the file or in personal.xlsb
Search for onkey in the vba.