excel calculation problem

  themobbster 17:10 10 Jan 2008
Locked

I have a fantasy football spreadsheet which contains a lot of different macros. When I run the macro that transfers a new player in to a team it runs ok for the first couple of transfers and then half way through the next I get a run time error which is caused by calculation being switched to manual from automatic. Any ideas please?

  VoG II 17:17 10 Jan 2008

Presumably this is in a loop? In the loop include

Application.Calculation = xlAutomatic

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?