#Value in FormulaArray

R

RussellT

May thanks to those who have helped me in the past.

I have a macro that places the following formula in Cell C8, but I always
get a #VALUE error.

DevDev, DevQtr and DevCumSPW are defined column ranges on the DevData
Worksheet.

reportsSheet.Range("C8").FormulaArray =
"=SUM(If((RC[-2],DevData!DevDev)*(FilterControl!R33C12=DevData!DevQtr),DevData!DevCumSPW))"

What's weird is a similar formula always works correctly.

reportsSheet.Range("E9").FormulaArray =
"=MAX(IF((R[-1]C[-4]=PlanData!PlanDev)*(FilterControl!R33C12=PlanData!PlanQtr),PlanData!PlanSqft))"

Any ideas why ones working and the other isn't
 
B

Bob Phillips

Have you checked that all of the range to be summed is numeric, no text
strings?

HTH

Bob
 

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

FormulaArray - Works in worksheet, not via Macros ? 2
Use count data in formula 1
Range.FormulaArray drops relative reference ? 4
FormulaArray 1
Sum If - Using the value of a parameter or constant in a formula tochange a condition 1
#VALUE! in cell 5
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Formula in macro gives "Run-time error '1004':" 1

Top