RE: Error 1004: application or object defined error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Resource in a dll
    ... If this is EXACTLY your problem, I'll upload them so they can look at it.. ... >> Hi Martin, ... >> Best regards, ... >> Gary Chang ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Hidden Files cant be shown
    ... Best regards ... You may zip the file and upload it to a free web hosting service. ... The Winhelponline Blog: http://www.winhelponline.com/blog ... hidden file settings. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Adoption & (il)Legitimate Heirs
    ... this newsgroup has a page with members devices, ... Best regards, ... If you don't have a web site: ... > the images you upload or you can just upload an image and hotlink to ...
    (rec.heraldry)
  • Re: Commas in filenames?
    ... dorayme wrote: ... errors in working with a bunch of files with lots of commas in ... Sometimes a program will execute a shell script from within the code; ... Yes the huge bunch of pics I have have lots of spaces in them ...
    (comp.sys.mac.system)
  • Re: Commas in filenames?
    ... dorayme writes: ... errors in working with a bunch of files with lots of commas in ... Sometimes a program will execute a shell script from within the code; ... Yes the huge bunch of pics I have have lots of spaces in them ...
    (comp.sys.mac.system)