RC[-2]
This is not like
regards
r


Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"Adhikarun" wrote:

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