Can anyone offer up a reason why the below VBA runs so slow? Can it be improved to run fast?
Cheers John
Please Login or Register to view this content.
Can anyone offer up a reason why the below VBA runs so slow? Can it be improved to run fast?
Cheers John
Please Login or Register to view this content.
Last edited by arlu1201; 02-23-2013 at 11:44 PM.
Maybe
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Shorter, hopefully quicker:
Please Login or Register to view this content.
So long as print area is the same for each sheet
Regards, TMS
Last edited by TMS; 02-23-2013 at 06:54 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
John_Day,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks SHG worked a treat!!!
TMS thanks also.
John
You're welcome.
I have to admit that I got carried away with the looping aspect and overlooked the differences for the first couple of sheets.
For completeness:
Please Login or Register to view this content.
No sheet or range selection. However, the Goto at the end will cause the Factory UTE sheet to be selected.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks