The screen didn't update properly when I ran VBA code when (A) I had frozen panes in Excel while I also (B) used Application.ScreenUpdating = False in VBA.

Setting Application.ScreenUpdating = True did not work to update the screen in the above. The following two options seemed to always work thus far: (1) Have VBA select a different tab before going back to the desired tab such as

Sheets("Sheet2").Select

Sheets("Sheet1").Select

(2) Turning Excel frozen panes off and then back on also worked

ActiveWindow.FreezePanes = False

ActiveWindow.ScrollRow = 1

ActiveWindow.ScrollColumn = 1

Range("A10").Select

ActiveWindow.FreezePanes = True