Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: #NAME!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wrote a macro that fills some columns with formulas. Simple ones, like "=H2+(H2*($H$3*D2))". It works just fine on my system, but I sent this spreadsheet to someone else and they say that they get the "#NAME!" error in every cell!

    I asked them to check the formula, and tell me what it says. From what they tell me, the formula is EXACTLY as it is on my system. But for them it produces the #NAME! error.

    We both are using Excel 2000. There is one difference between the versions though. He is in the UK, and I am here in the US. Could that be the problem? And if so, how could I fix it?

    Thanks for any help!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can trace all precedents beginning with the cell containing the formula, =H2+(H2*($H$3*D2)), back to the cell that generated the #NAME? error by using the Trace Error button on the Auditing tool bar. The Auditing tool bar found under the Tools | Auditing menu path.

    [ This Message was edited by: Mark W. on 2002-03-11 15:26 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I send excel 97 docs all arround the world with scripts and formulas a milluions hitch free, my friends in New York and so on dont have issues like this all is perfect.

    There are many US posters that can check with luck and advise differences, that cound not defaults to $ not GBP. I mean thigs that matter

    I was sent your like this in 1995 office 95 on floppy fron Canada by a charity i was helping and on 45 floppys! thats had odd things about it it was CANADIAN version, Barrie Davidson is form Canada might he know....


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could be using formulas that come from an AddIn.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •