Selection.QueryTable.Refresh causes screen blinking

C

CY

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top