Performance - autofilter vs loop
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? |
Performance - autofilter vs loop
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. "ka2cil" wrote: 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? |
All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com