Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work around for limit on entering array formulas?
I have an array formula that is 546 characters in length that I am trying to
place in a spreadsheet programmatically using the following syntax: ActiveCell.FormulaArray = strFormula But, this fails with the error: "Unable to set the formula array property of the range class" This method works with shorter formulas, is there a limit? If so, how do I work around this? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work around for limit on entering array formulas?
There is a limit of 255 with FormulaArray:
http://support.microsoft.com/default...b;en-us;213181 Break it up? Use short range names instead of ranges? Might be tough to carve off 300 characters. -- Jim Rech Excel MVP "quartz" wrote in message ... |I have an array formula that is 546 characters in length that I am trying to | place in a spreadsheet programmatically using the following syntax: | | ActiveCell.FormulaArray = strFormula | | But, this fails with the error: "Unable to set the formula array property of | the range class" | | This method works with shorter formulas, is there a limit? If so, how do I | work around this? | | Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work around for limit on entering array formulas?
Thanks Jim. That's too bad. My solution is rendered unusable.
It's strange that I can enter the formula manually, just not in code. Thanks for your response. "Jim Rech" wrote: There is a limit of 255 with FormulaArray: http://support.microsoft.com/default...b;en-us;213181 Break it up? Use short range names instead of ranges? Might be tough to carve off 300 characters. -- Jim Rech Excel MVP "quartz" wrote in message ... |I have an array formula that is 546 characters in length that I am trying to | place in a spreadsheet programmatically using the following syntax: | | ActiveCell.FormulaArray = strFormula | | But, this fails with the error: "Unable to set the formula array property of | the range class" | | This method works with shorter formulas, is there a limit? If so, how do I | work around this? | | Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas assignment from array to range in VSTO Excel doesn't work | Excel Worksheet Functions | |||
entering as an array | Excel Discussion (Misc queries) | |||
Can array formulas work if rows are inserted? | Excel Worksheet Functions | |||
Entering Array Functions | Excel Discussion (Misc queries) | |||
entering individual array formulas with vba | Excel Programming |