| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Helpme with Forumal Array option
I get the following error while trying to run the Macro, I just started
learing. "Unable to set the formulaArray Property of the Range class - Error" Selection.FormulaArray = "=SUM(IF('Email Raw Data'!R1C1:R900C1=RC[-2],IF('Email Raw Data'!R1C11:R900C11=""Service Desk Queue"",1,0),0))+SUM(IF('Email Raw Data'!R1C1:R900C1=RC[-2],IF('Email Raw Data'!R1C11:R900C11=""(None)"",1,0),0))+SUM(IF('Em ail Raw Data'!R1C1:R900C1=RC[-2],IF('Email Raw Data'!R1C11:R900C11=""Miscellaneous Queue"",1,0),0))" Thanks for you Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then forumal | Excel Worksheet Functions | |||
| Worksheet forumal help | Setting up and Configuration of Excel | |||
| Seeking Help with a forumal. | Excel Programming | |||
| Having problem with subtotal helpme out | Excel Programming | |||
| forumal does not work | Excel Worksheet Functions | |||
Threaded Mode
