VBA running significantly slower the more times i run it

[Whitethorn]

Hi All,

Unfortunately i am not able to share my code due to privacy reasons. However i have been writing a number of macros to do some forecasting. The problem that i am experiencing is that when i run the macros 5 times i get stuck at a certain percentage and it then takes ages for any progress to be made from here. Does anyone have any ideas as to how i could speed things up. The only thing i can think of is that data is being held in memory when it shouldn't be and thus clogging up calculation time.

Any help would be much appreciated.

[nigelog]

Impossible to say unfortunately with so little to go on

[Tinbendr]

String manipulation, arrays... be sure to release objects when complete. Move repetitive calculations to function/subs.

[Whitethorn]

thanks for the feedback - realise it's not much to go on!

What do you mean by releasing object when complete?

[Tinbendr]

thanks for the feedback - realise it's not much to go on!

What do you mean by releasing object when complete?

If you define a variable/object, set it to null or nothing after task finished.