View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CY CY is offline
external usenet poster
 
Posts: 1
Default 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