macro takes forever to complete
I use this macro to hide older than today rows.
The problem is that it runs for the already hidden rows and thus it takes forever to complete
because there are more than 1500 rows in the table...
ver
office 2019 and office 2021
Any ideas??
--------------------------------------
Please Login or Register to view this content.
Last edited by AliGW; 08-15-2023 at 06:41 AM. Reason: Code tags added - please review the forum rules.
Welcome to the forum.
Please review the forum rules on code tags. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try
Please Login or Register to view this content.
Aha !
This one worked just fine. Thank you!
If I unhide all rows and run it it still takes long time to complete.
But if rows are hidden and needs to hide 10 more (from yesterday)
it works perfect.
So, Thank you again
Pete
Re: macro takes forever to complete
As a reminder filtering data just replaces the useless slow loop …
I agree butOriginally Posted by Marc L
saving a filter as macro to be attached to a button
is not my expertise yet :-)
I use filters else were in my sheets but I don't know how to do this one.
Thanks !
Re: macro takes forever to complete
So easy to start yourself just activating the Macro Recorder and operating manually …
For more help attach at least a workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks