When I hit Ctrl/End the cursor moves to row 1046470. My actual valid data ends at row 2326.
I had this problem in the past and got the following macro solution from help on the forum.
This did not work this time - I may have still been on excel 2003 and am now on excel 2016.
I'm attaching a text file of a macro I've been running to try to reset the worksheet to the valid last row.
I commented out all of the different options I've tried after they failed to solve the issue.
I also selected about 5000 rows and used the 'Clear All' option and then deleted them.
I did a save and exit the workbook after each attempt but nothing has worked yet.
Thanks in advance for any help.
Bookmarks