Hi All,

Has anyone encountered any issue with Application.Calculate causing Syntax errors?
The error message in particular is Run-time error '1004'. Cannot run visual basic macro because of a syntax error.

I am very confident that the rest of the code is working. This error also happens when Application.Calculate is executed via the Immediate window.

Due to the usual disclosure thingy, I can't provide the code that I am currently working on but I've done some research online and there are others who face these issues back in 2007 and was never resolved, one of which is http://www.officekb.com/Uwe/Forum.as...tion-Calculate

I am just wondering if anyone ever encountered this kind of problem and what did you do to fix it, if any.