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

--
Message posted from http://www.ExcelForum.com