반응형
'sub ajksndjklasd() 아래
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Application.EnableEvents = False
Application.CutCopyMode = False
Application.Calculation = xlCalculationAutomatic
Application.AskToUpdateLinks = True
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Application.EnableEvents = True
Application.DisplayStatusBar = True
'end sub 위
소스 그대로, 기능들을 껐다가 다시 킴으로써, 디버깅을 훨씬 빠르게 해준다.
#엑셀
#vba
#excel
반응형