Error 2015 from ConvertFormula

G

Gordon

When the input formula gets longer than about 230 characters,
convertformula returns Error 2015. I get this response in Excel
versions 97 and 2000 with both Windows 2000 and Mac OS 9.2 (excel 98).

Has anyone run into this? Does anyone have a work around -- I wrote
the Macro because the formulas I need to manipulate can be many, many
more than 230 characters.

Gordo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 1004: Select method of worksheet class failed 3
Excel Saving Issues 1
Getting around .FormulaArray limits 0
Querytables.add with sql query text stored in separate text file 5
Unable to set the FormulaArray property in Excel 97 0
Evaluate v. WorksheetFunction: best practice? 6
Incompatible Excel 97-2000 and 2007 1
Workbook used as pricing calculator 3

Top