Filtering slows down a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two similar macros that usually takes 45 seconds to run however one of
them takes 4 minutes to run with the only difference is the filtering from
one group to another. I have narrowed it down to the filtering portion of the
macro that takes so long, can anyone tell me why this one macro is doing this
or a fix for it? Thanks for any help you can offer.
 
When you change the filter, excel will recalculate.

Maybe you could turn calculation to manual, do the work, then turn it back to
what it was.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy value in field and insert it into filter 2
Slow data filtering 5
Use the custom filter dialog in a macro 3
shared workbook - macros using advanced filter - substiitution nee 1
Pasting cell contents into a macro 1
Data Filter drop down 3
Is there a way to link Auto Filter values to a Cell 2
how to create macro to use cell references for data filter criteri 3

Back
Top