Posted to microsoft.public.excel.programming

quartz[_2_] quartz[_2_] is offline

external usenet poster

Posts: 441

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulas assignment from array to range in VSTO Excel doesn't work	vsto excel array to range	Excel Worksheet Functions	0	December 11th 07 04:48 PM
entering as an array	Alfonso	Excel Discussion (Misc queries)	0	October 5th 06 04:48 PM
Can array formulas work if rows are inserted?	Chris	Excel Worksheet Functions	1	March 16th 06 03:30 PM
Entering Array Functions	Jaytee	Excel Discussion (Misc queries)	1	August 28th 05 04:11 PM
entering individual array formulas with vba	tom[_5_]	Excel Programming	3	January 6th 04 10:44 AM

All times are GMT +1. The time now is 11:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us