View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adhikarun Adhikarun is offline
external usenet poster
 
Posts: 1
Default 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