excel calculation problem

  themobbster 17:10 10 Jan 08
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 08

Presumably this is in a loop? In the loop include

Application.Calculation = xlAutomatic

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

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…