Screen flicker despite ScreenUpdate = False in the first line of code

  • Thread starter Gunnar Johansson
  • Start date
G

Gunnar Johansson

Hi,

I have "Application.ScreenUpdate = False" in first row after "Sub.." and has
it as "= True" the last line just before "End Sub"

Why does my screen still flicker irritating when I run the code? What can I
do to prevent it?

/Regards
 
K

Ken Macksey

Hi Don't know if the typo is just in your message, but try

Application.ScreenUpdating = False


instead of Application.ScreenUpdate = false

HTH

Ken
 
J

Jason Morse

Gunnar said:
Hi,

I have "Application.ScreenUpdate = False" in first row after "Sub.." and has
it as "= True" the last line just before "End Sub"

Why does my screen still flicker irritating when I run the code? What can I
do to prevent it?

/Regards
Click to expand...

Assuming this isn't a typo issue...
Do you have use any AutoFilters in the code? I have found that they can
produce flicker even when ScreenUpdating = False. I've worked around
this by turning ScreenUpdating off *again* when finished with the
Autofilters.

-Jason
 
Top