Application-Defined or Object Define error? Help please.
 

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

Application-Defined or Object Define error? Help please.
 

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

"NooK " wrote in message
...
I am trying to fill a cell with a formula and I have tried everything
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, but
even if I change the variables to numbers fro testing still the same
error.

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

Hope someone has an idea why.

Best Regards

NooK


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

Application-Defined or Object Define error? Help please.
 

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

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