Excel VBA Performance
Many factor can influence the performance in Excel VBA. Here is an enumeration of the most frequent and important.
Application.Screenupdating
Application.EnableEvents
Application.Calculation = xlCalculationManual
Application.Volatile