J
jasonsweeney
I ran a macro, from a useform, that inserted about 100 comments int
cells on 10 different worksheets.
As many have talked about in this forum, the screen "flashed" durig
execution of the macro, despite that in the code was written:
_________
Application.ScreenUpdating = False
' Sheet1 code
' Sheet2 code
' etc.
Application.Screenupdating = True
__________
For giggles, I changed the code to:
_________
Application.ScreenUpdating = False
' Sheet1 code
Application.Screenupdating = True
'
Application.ScreenUpdating = False
' Sheet2code
Application.Screenupdating = True
'
Application.ScreenUpdating = False
' etx.
Application.Screenupdating = True
__________
Of course, this did not solve the problem, as many have commented.
Then I tried this:
Application.ScreenUpdating = False
' Sheet1 code
Application.ScreenUpdating = False
' Sheet2code
Application.ScreenUpdating = False
' Sheet3.code
Application.Screenupdating = False
' Etc.
Application.Screenupdating = False
And,.........it Worked! I only got one screen "flash" by doing it thi
way. The macro still wasn't as quick as one would desire, but it di
solve the flashing issue. Just wondering if anybody else ha
experienced success with this strategy.
Jason Sweene
cells on 10 different worksheets.
As many have talked about in this forum, the screen "flashed" durig
execution of the macro, despite that in the code was written:
_________
Application.ScreenUpdating = False
' Sheet1 code
' Sheet2 code
' etc.
Application.Screenupdating = True
__________
For giggles, I changed the code to:
_________
Application.ScreenUpdating = False
' Sheet1 code
Application.Screenupdating = True
'
Application.ScreenUpdating = False
' Sheet2code
Application.Screenupdating = True
'
Application.ScreenUpdating = False
' etx.
Application.Screenupdating = True
__________
Of course, this did not solve the problem, as many have commented.
Then I tried this:
Application.ScreenUpdating = False
' Sheet1 code
Application.ScreenUpdating = False
' Sheet2code
Application.ScreenUpdating = False
' Sheet3.code
Application.Screenupdating = False
' Etc.
Application.Screenupdating = False
And,.........it Worked! I only got one screen "flash" by doing it thi
way. The macro still wasn't as quick as one would desire, but it di
solve the flashing issue. Just wondering if anybody else ha
experienced success with this strategy.
Jason Sweene