Hey

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