Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Value in FormulaArray
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!Dev Qtr),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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Value in FormulaArray
Have you checked that all of the range to be summed is numeric, no text
strings? HTH Bob "RussellT" wrote in message ... 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!Dev Qtr),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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FormulaArray limits? | Excel Programming | |||
Using FormulaArray in VBA | Excel Programming | |||
FormulaArray | Excel Worksheet Functions | |||
FormulaArray..... HELP !!! | Excel Programming | |||
FormulaArray | Excel Programming |