![]() |
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 |
All times are GMT +1. The time now is 09:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com