Hey
I want speed up my refreshing query with adding this code in before refresh all event
and this after refresh all eventApplication.Calculation = xlCalculationManual Application.ScreenUpdating = False
but what the event name for this two event?Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True
Bookmarks