I have a spreadsheet that previously worked but today keeps giving me overflow errors all the time, mostly when I call the Application,Calculation function:
I've read that this has to do with numbers being larger than their max, but I don't think that's the case here. I also read that it can have something to do with Temporary folder space? Those are two very different causes!
Please Login or Register to view this content.
The Application.Calculation function doesn't actually do any calculating, does it? Isn't it just supposed to return the method of calculation? Why would that keep giving me this error? I've tried using variable types other than Double for the return value, but to no avail. Double seems to work more often than the others.
Thanks for any suggestions!