79190891

Date: 2024-11-15 01:54:05
Score: 1.5
Natty:
Report link

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

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Paul Fraser