I have a problem with the following lines in my Macro:


Range("c2").Select
Selection.FormulaArray = _
"=SUM(IF(jobno,RC[-2],IF(Dept=$R$1C,IF(Sun=""Not"",IF(Status<""No
Charge"",Ratecard,0),0),0)))"

jobno, Dept, Sun, Status and Ratecard are range names (and are all of equal
length, so that is not my problem).

I get the following error message : Run-time error'1004' Unable to set the
FormulaArray property of the range class.

I am using Excel 2002 SP3.

Thanks in advance

Craig