I am new to VBA and trying to put a formula in that is essentially just a sum function.

It's basically: =sum(A1:A5)

And it works - except it doesn't. When I click on it, it shows that it's working (i.e. it highlights the sum range as if it's calculating), but nothing sums up when I start entering numbers? I've put this into the code but it still doesn't work: Application.calculation = xlCalculationAutomatic

I've searched the site and google for a solution and it seems other people have had a similar problem but I can't find/understand the solution. Thanks in advance for any help!

CodePudding user response：

Try this answer https://stackoverflow.com/a/154439/10645228

So you're close - switch it off and on again!