Speed up Macro

[jbrooks1988]

Hi all

I have this macro which searches through dozens of spreadsheets based on a specified list, here is the code:

Basically I am looking at ways to speed up the the running of the macro as it takes about 15 minutes to go through about 50 spreadsheets. Attached is the report runner spreadsheet this macro is contained in (Unsold Tickets button in 'Unsold Ticket Report'). Also attached is a sample spreadsheet where the data is pulled from (Judas Priest) and the template where the information is output on (Unsold Tickets). Thank you in advance!

Please Login or Register  to view this content.

[kleptilian]

The first thing to try would be adding

Please Login or Register  to view this content.

to the beggining of the macro and

Please Login or Register  to view this content.

to the end.

[Tinbendr]

Turned screen updating off. Defined worksheets to use fully qualified to use as objects. Turned all activates off.
I can't test it, of course, but good luck.

Please Login or Register  to view this content.

[jbrooks1988]

Thanks for this guys, I have used kleptilian's coding and worked in a flash. I tried the above complete code but couldnt find the Unsold Tickets file.