I have a large spreadsheet with an array and several macros. For some reason, auto-calc keeps turning off and I can't figure out why. I have had to resort to putting a line in WB.open and WS.activate to ensure this doesn't happen.
I've been over my code and can't see it, but I have little understanding of the array and was wondering if that could be it. Any reason that pops out for you?![]()
Application.Calculation = xlAutomatic
Thanks
Russ
Bookmarks