excel calculation problem

  themobbster 17:10 10 Jan 2008

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

Dell XPS 13 9370 (2018) review

HomePod review

Comment regarder les Oscars 2018 ?