Can someone help me to revise my code to make it run faster in a large amount of data...
My data usually handles 50K records. The macro seems not working because it took me an hour when it reaches this code:
Please Login or Register to view this content.
I don't see anything noticeably wrong with the deletion of all the rows at once via an AutoFilter. Perhaps the "lag" is coming from the time it takes your sheet to recalculate after the deletion while still filtered? One thing you can try is setting the calculationmode to manual prior to the deletion, and back to automatic when you're done with all the fiddling.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks