Application-Defined or Object Define error? Help please.

[NooK]

I am trying to fill a cell with a formula and I have tried everythin
but I keep getting:

Error 1004: Aplication-Defined or Object-Defined error

Basically here is the line I try to enter the fornula


Cells(Fzc, 17) = "=IF(M" + CStr(Fzc) + "=0;L" + CStr(Fzc) + "*Q$"
CStr(n + 1) + ";0)"


I have also tried

Cells(Fzc, 17) .FormulaR1C1 = "=IF(RC[-4]=0;RC[-3]*R[n+1]C;0)"

There is nothing wrong apparently, Fzc is a long and n an Integer, bu
even if I change the variables to numbers fro testing still the sam
error.

If I take away the "=" from the string it works fine otherwise I ge
the error.

Hope someone has an idea why.

Best Regards

Noo

 

[Don Lloyd]

Try replacing all of the + signs (except the n+1) with &

 

[NooK]

As I said I have tried everything with RC1 notation but when I tried th
other notation (With String concatenation) with FormulaLocal it worked
or replacing the ; did the same job.

Thanks for the help and sorry for any bothering.

Best Regards

Noo