hi,
I have a macro that clears many lines of a report
however it takes forever and I am looking for the most efficient way
I saw somewhere that grouping them in a range and then deleting it should be a good idea, but maybe if it is it makes the whole system irresponsive for too long
sorting the rows at the end is a good idea? (and then clear contents or so)
maybe I'll try that, but I'm open to suggestions
thank you!
You could filter the rows based on your criteria for deletion and then delete the visible rows only.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Apart from filtering, sorting the rows is a good idea too. You can either clear or delete them.
Of course standard mesures, like switching of automatic calculation and screen updating are always worth using.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks