Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |