Advanced Filters - improve performance ?

  • Thread starter Thread starter IrelandA
  • Start date Start date
I

IrelandA

Dear All

Can anyone give any tips/advice on how to improve the performance of
Advanced Filters. (Additional VBA code, etc).

At the moment, my filter (working on a VBA macro) takes almost 2 minutes to
complete a range of about 1500 rows by 8 columns which is much longer than I
was expecting.

Any advice gratefully received.

Regards

Al
 
try adding:
With Application
.Calculation = xlManual
.ScreenUpdating = False
End With

* your code here *

With Application
.Calculation = xlAutomatic
.ScreenUpdating = True
End With
 
Back
Top