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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
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 |