Performance - autofilter vs loop

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

Guest

I have certain text in report header/footer that I do formatting with a
macro. I was just curious about the performance of autofilter vs looping
through the report. For smaller reports, it may not matter much. How about
for larger reports? Any preference?
 
I have a current report with over 5000 rows... I tried looping through it and
it took fooooooorever. When I switched it to a formula and copied the formula
down to Range.End(xlDown).Row, it cut the time by about 90 times faster.

I only loop now if it's my last and best option and it's small enough to
maintain.
 
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

Weird ignoring of one item in a loop 5
Exclude header row when copying autofilter results? (XL2003) 1
deleting cells: Auto filter or loop or what 5
Autofilter each item in a list 2
Enable autofilter in protected worksheets in Excel 2000 6
manipulating results of autofilter in vba 6
Please explain this AutoFilter procedure 6
unhide all rows without loop 2

Back
Top