View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IrelandA IrelandA is offline
external usenet poster
 
Posts: 1
Default Advanced Filters - improve performance ?

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