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
|