Macro runs quick initially then bogs down after a few runs

I have a macro that uses a workbook to populate 2 other workbooks. It runs quickly when I first open the 3 workbooks (approx. 5 to 10 seconds). In my testing I run the macro several times when the source book changes. After approx. 3 or 4 runs the macro is exceedingly slow. My latest run was over 5 minutes and counting. I interrupted the flow and the macro was not in a continuous loop.

I closed all 3 books, re-opened them and ran the marcro again in 5 to 10 seconds.

Is there some command I need to run to reset a stack or something?

Thanks for any advice.

Originally Posted by pongmeister

... command...to run .. reset ... or something?

Try e.g. 'End' statement:

Please Login or Register  to view this content.

But this is not a forum for fairies and clairvoyants, give us any example.
Maybe somewhere there are not reset arrays, variables, object assignments ?
Maybe too many formulas in the cells of the worksheets ?
Who knows ... abracadabra ...

OK, good point - I've attached the 3 workbooks.

The source workbook is; WebDownLoad.xlsm
The first target workbook is: Tournament Register.xlsm and contains the macro: WebLoad
The second target workbook is: Web Player List.xlsm

many 'Select/Selection', external references, many modules ... module on the module ... and module for every occasion ...

Thank You, I will cleanup the unused modules and mark this post closed