Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004: application or object defined error
Hi
I upload a bunch of information to a sheet, including simple formulas like =A1/A2 etc. There is one IF, and that causes the error: Worksheets("Start").Cells(j, 6) = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" I have tried Worksheets("Start").Cells(j, 6).Formula but that does not change much If I remove the equals (=) sign, then it works, and I can add it afterwards manually, and it will work. The formula is correct, I just can set it. I even added a DoEvents before - no change. What do I do wrong here? I browsed the group, but did not find anything on this specific case. WBR Sonnich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004: application or object defined error
Worksheets("Start").Cells(j, 6).Formula = "=if(B7=0;E" & sLine & ";E" &
sLine & "/B7)" -- If this post helps click Yes --------------- Jacob Skaria "jodleren" wrote: Hi I upload a bunch of information to a sheet, including simple formulas like =A1/A2 etc. There is one IF, and that causes the error: Worksheets("Start").Cells(j, 6) = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" I have tried Worksheets("Start").Cells(j, 6).Formula but that does not change much If I remove the equals (=) sign, then it works, and I can add it afterwards manually, and it will work. The formula is correct, I just can set it. I even added a DoEvents before - no change. What do I do wrong here? I browsed the group, but did not find anything on this specific case. WBR Sonnich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004: application or object defined error
hi
if i am reading correctly, your formula seems to have simi colons instead of commas. try this. Worksheets("sheet1").Cells(6, "j") = "=if(B7=0,E" & sLine & ",E" & sLine & "/B7)" regards FSt1 "jodleren" wrote: Hi I upload a bunch of information to a sheet, including simple formulas like =A1/A2 etc. There is one IF, and that causes the error: Worksheets("Start").Cells(j, 6) = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" I have tried Worksheets("Start").Cells(j, 6).Formula but that does not change much If I remove the equals (=) sign, then it works, and I can add it afterwards manually, and it will work. The formula is correct, I just can set it. I even added a DoEvents before - no change. What do I do wrong here? I browsed the group, but did not find anything on this specific case. WBR Sonnich |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004: application or object defined error
Oops...Review your formula closely to identify the semicolons . It should be
commas -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Worksheets("Start").Cells(j, 6).Formula = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" -- If this post helps click Yes --------------- Jacob Skaria "jodleren" wrote: Hi I upload a bunch of information to a sheet, including simple formulas like =A1/A2 etc. There is one IF, and that causes the error: Worksheets("Start").Cells(j, 6) = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" I have tried Worksheets("Start").Cells(j, 6).Formula but that does not change much If I remove the equals (=) sign, then it works, and I can add it afterwards manually, and it will work. The formula is correct, I just can set it. I even added a DoEvents before - no change. What do I do wrong here? I browsed the group, but did not find anything on this specific case. WBR Sonnich |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004: application or object defined error
On Apr 17, 7:12*pm, FSt1 wrote:
hi if i am reading correctly, your formula seems to have simi colons instead of commas. try this. Worksheets("sheet1").Cells(6, "j") = "=if(B7=0,E" & sLine & ",E" & sLine & "/B7)" regards FSt1 "jodleren" wrote: Hi I upload a bunch of information to a sheet, including simple formulas like =A1/A2 etc. There is one IF, and that causes the error: * * Worksheets("Start").Cells(j, 6) = "=if(B7=0;E" & sLine & ";E" & sLine & "/B7)" I have tried Worksheets("Start").Cells(j, 6).Formula but that does not change much If I remove the equals (=) sign, then it works, and I can add it afterwards manually, and it will work. The formula is correct, I just can set it. I even added a DoEvents before - no change. What do I do wrong here? I browsed the group, but did not find anything on this specific case. WBR Sonnich That was it. God, I could not see the forest, there were some trees in front of it. WBR & thanks Sonnich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': Application defined or Object defined error | Excel Programming | |||
Run-Time error 1004 Application defined or object defined error - | Excel Programming | |||
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
Run-time Error 1004: Application-defined or Object-defined Error | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming |