I had similar issues and seems like it may be resolved with one of the following ways:
(1) Have VBA switch to a different tab and then back to the tab you want right before ending the code such as using:
(1a) Sheets("sheet2").Select
(1b) Sheets("sheet1").Select or
(2) Turn off Frozen Panes in Excel or
(3) Don't use Application.ScreenUpdating = False but the code runs slower so options 1 may be the best followed by option 2