Masochists only: Empty workbook, but Control End goes to FQ1.
Posted on 2016-09-14
From time to time I find weird worksheets where Control End goes to an unexpected cell.
Copying the entire worksheet to a new worksheet also copies the weirdness.
The only way to get rid of the problem is to select the entire used range and copy it into a new sheet and delete the old sheet.
Can anybody find a different way to solve the problem?
It seems to originate when a large worksheet uses autofilter, and then turns off autofilter. It might also be related to deleting a pivot table.