This code is pretty simple but when I run it, it takes a good five minutes to see the results because there is a lot of sheets and cells.
Can this code be simplified to be executed faster?
Please Login or Register to view this content.
This code is pretty simple but when I run it, it takes a good five minutes to see the results because there is a lot of sheets and cells.
Can this code be simplified to be executed faster?
Please Login or Register to view this content.
Last edited by SIMBAtheCAT; 06-30-2014 at 10:56 AM.
application.calculation=xlcalculationmanual at the start
and
application.calculation=xlcalculationautomatic at the end.
Wrap the formula in error traping to stop the 2nd loop
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
This might be faster:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Both ideas work!
Thank you, it is appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks