Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
Application-defined or object-defined error | Excel Programming | |||
Runtime Error 1004 -- Application Defined or Object Defined Error | Excel Programming |