I have many routines that set the .Formula of chart series. In one routine I'm getting intermittent run time errors that say...
A formula in this worksheet contains one or more invalid references. Verify that your formulas contain a valid path, workbook, range name, and cell reference.
I'm confident there is nothing wrong with the formula string. If I click the Debug button, and then press F5, the code continues and executes correctly without the error.
This problem is unique to Excel 2007 and 2010. It does not happen with Excel 2003. The fact that the code continues by pressing F5 must be a clue, but I'm clueless.
Does anyone have any suggestions on what the problem could be?
Thanks,
Brian in Austin, Texas
Bookmarks