unable to set the formula array property of the range class

Posted to microsoft.public.excel.worksheet.functions

JLP

external usenet poster

Posts: 4

unable to set the formula array property of the range class

I get the error message 'unable to set the formula array property of the
range class' when I am using a conditional sum function. The data - the
range - is on one worksheet and the result of the calculation is on another
worksheet. If both the data and the result are on the same worksheet, no
error message. Anyone have any ideas?

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
Unable to get the Interior property of the PlotArea class	[email protected]	Charts and Charting in Excel	2	September 3rd 08 03:41 PM
Unable to set the XValues property of the Series class	Ben	Charts and Charting in Excel	7	December 7th 06 10:01 PM
Unable to set the Values property of the Series class	rafael garcia	Charts and Charting in Excel	1	September 25th 06 04:31 PM
Unable to set the formula property of the series class	Malhar	Charts and Charting in Excel	1	July 24th 06 05:50 PM
Unable to set the XValues property of the Series class	ramkumar_cpt	Charts and Charting in Excel	5	November 29th 05 02:13 PM

All times are GMT +1. The time now is 08:23 AM.

Menu

About Us