LinkBack URL
About LinkBacks
Thank you for your time ...
Do you know how to edit the following macro so it processes the data faster ? There are 79,299 rows to be updated with the current time.
Please Login or Register to view this content.
Thank you for your time ...
Do you know how to edit the following macro so it processes the data faster ? There are 79,299 rows to be updated with the current time.
Please Login or Register to view this content.
Something like this for starters.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I would suggest you drop the entire column F into an array. Then loop through that to create an output array, and drop that into column G.
It's basically the same loop as you have but inputting and outputting array entries.
I'm on an iPad so I can't do it just now.
Edit: in fact, that's what bakerman2 has done for you.
Last edited by TMS; 12-12-2024 at 07:10 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Just ahead of you Trevor.
I know. Just glad I didn't actually spend the time doing it. Though I’d probably have used a single column array for the G entries.Originally Posted by bakerman2
Just ahead of you Trevor.
WOW !!!!
Talk about speed ! What took 3 minutes to complete previously now only takes 0 seconds !!!!!!!
Thank you SO MUCH.
You're welcome. Thanks for the rep.
Glad to help. Thanks for Rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks