Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ConvertFormula Problem
I am unable to convert the following cell's formula:
"='Standard Model'!E34+'Standard Model'!E36+'Standard Model'!E37+'Standard Model'!E38+'Standard Model'!E39+'Standard Model'!E32+'Standard Model'!E41" The cell is 'A1' in 'Standard Model' worksheet 'MyWorkbook.xls' workbook I am using: Application.ConvertFormula(ActiveCell.FormulaR1C1, xlR1C1,xlA1,true,ActiveCell) I get variant "Error 2015" back. I *think* this is due to ConvertFormula appending the workbook name to each reference internally and exceeding some string size limitation? Are there any workarounds for this - I am using the ConvertFormula in this way to standardise any formula to a $A$1 type. This is in preparation for tokenising the references based on the $'s. Any help would be appreciated, Ant |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Error 2015 from ConvertFormula | Excel Programming |