Hot answers tagged


I will address your code in sections and at the end I will provide a full updated code based on the touched subjects. Application state You are turning the Application 'off' with: Application.ScreenUpdating = False Application.Calculation = xlManual Application.DisplayAlerts = False at the beginning of your method and then you turn it back 'on' with: ...

Only top voted, non community-wiki answers of a minimum length are eligible