Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.QueryTable.Refresh causes screen blinking
Hello,
I have a macro looks like that: Sub Macro1() 'Application.ScreenUpdating = False Selection.QueryTable.Refresh BackgroundQuery:=False Application.OnTime Now + TimeValue("00:00:01"), "Macro1" 'Application.ScreenUpdating = True End Sub The excel screen blinks every 1 second. It is quite annoying. I want to make sure that there is no way to stop the blinking even with "Application.ScreenUpdating = False" which I have tried. Thanks, CY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blinking/flickering screen | Excel Discussion (Misc queries) | |||
QueryTable Refresh Failed | Excel Programming | |||
QueryTable Last Refresh Date? | Excel Programming | |||
I need a QueryTable.Refresh solution | Excel Programming | |||
catching cancel on QueryTable.Refresh | Excel Programming |