Macro running time

[Dota2014]

Hi all,


I was just wondering if anyone experienced something similar. The time required for running one of my Macros is around 30 seconds, but sometimes it took as long as 30 minutes. And then other times it took only 30 seconds. Anyone happens to know why so?

 

[JoeMo]

Hi all,


I was just wondering if anyone experienced something similar. The time required for running one of my Macros is around 30 seconds, but sometimes it took as long as 30 minutes. And then other times it took only 30 seconds. Anyone happens to know why so?

Hard to say without seeing the macro and knowing what the workbook(s) it operates on contains.

 

[Dota2014]

Hard to say without seeing the macro and knowing what the workbook(s) it operates on contains.

Any common causes?

 

[JoeMo]

Any common causes?

Poorly constructed code, failure to turn off calculations in formula-heavy workbooks, failure to turn off screen updating, failure to disable events (if any) while code is executing ........

 

[Dota2014]

Poorly constructed code, failure to turn off calculations in formula-heavy workbooks, failure to turn off screen updating, failure to disable events (if any) while code is executing ........

I don't know about poorly constructed codes, but other categories you have mentioned were under control.

It just that it took 30 minutes to run the Macro yesterday. I ran the same Macro today, and it only took 30 seconds. Nothing have changed.

If my codes were bad, then shouldn't it take 30 minutes each time?

Thanks for your input btw.

 

[JoeMo]

I don't know about poorly constructed codes, but other categories you have mentioned were under control.

It just that it took 30 minutes to run the Macro yesterday. I ran the same Macro today, and it only took 30 seconds. Nothing have changed.

If my codes were bad, then shouldn't it take 30 minutes each time?

Thanks for your input btw.

Depends on what other workbooks are open, what's in them, other applications that are open, .........
30 seconds to 30 minutes is a big swing.