Array error

[Craig]

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

 

[Bob Phillips]

Try

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

 

[Craig]

Thanks Bob.

Try

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

--
HTH

Bob Phillips

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