+ Reply to Thread
Results 1 to 8 of 8

Name Manager Question

  1. #1
    Registered User
    Join Date
    02-13-2018
    Location
    CA
    MS-Off Ver
    2007
    Posts
    5

    Name Manager Question

    I think I found an error in a spreadsheet that I am using and as such I am trying to look into the formula that is used to figure out why the cell value is coming out the way that it is.

    The cell in question uses a created name, and when i go to the Name Manager and under refers to is says 'Foot-Meter'!$A$2. However, cell A2 does not have anything in it and not being too familiar with creating Names, I'm not sure what is going on here.

    Thanks for the help!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Name Manager Question

    Hi MotrColt. Welcome to the forum.

    In this case the formula is referencing a single cell 'Foot-Meter'!$A$2 by a name.

    Try replacing the Named references in your formula with the literal 'Foot-Meter'!$A$2. It may be easier to understand. If that is a blank or is evaluated in your formula as 0 is it easier to see where the error might be coming from?
    Dave

  3. #3
    Registered User
    Join Date
    02-13-2018
    Location
    CA
    MS-Off Ver
    2007
    Posts
    5

    Re: Name Manager Question

    Thanks for the response!

    I entered 'Foot-Meter'!$A$2 into Cell E5 and I got the confusing value 38.237. I used the Evaluate Formula button and this is what comes up:

    Sheet1!$E$5 = 'Foot-Meter'!$A$2

    -step in
    'Foot-Meter...!$A$2 = G50

    -step in
    'Foot-Meter...!$G$50 = IF(HandleX="Yes",H50*10,I50*10)

    -step in
    HandleX = Sheet1!$A$5


    Now cell A5 does have a Yes in it and that part makes sense to me, however, other than that the rest of the cells are blank; G50, H50, and I50 are all blank and if I go into a cell and type =G50 or =H50 or =I50 they all result in a 0 value. Also if I got to G50, H50, and I50 and press trace precedents/dependents it says that there are none. All of this is true for A2 as well.

    The cells on the corresponding cells on the spreadsheet do not seem to be being referenced and I'm not really sure what the 'Foot-Meter'! part is running in order to obtain the value of 38.273
    Last edited by jeffreybrown; 02-13-2018 at 08:59 PM. Reason: Removed full quote!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Name Manager Question

    Whew.

    H50*10 and I50*10 would evaluate to 0 if those are blank.

    But I would need an uploaded Excel workbook to sort this goblin out!

    If you aren't familiar with how to do this:


    To attach a file to your post,
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Last edited by FlameRetired; 02-13-2018 at 08:51 PM.

  5. #5
    Registered User
    Join Date
    02-13-2018
    Location
    CA
    MS-Off Ver
    2007
    Posts
    5

    Re: Name Manager Question

    Alright well it will probably take me a while to desensitize the data, I'll try and get it up tomorrow. Thanks for the help!

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Name Manager Question

    You bet.

    I'm Subscribed to this thread. I'll stay alert.

  7. #7
    Registered User
    Join Date
    02-13-2018
    Location
    CA
    MS-Off Ver
    2007
    Posts
    5

    Re: Name Manager Question

    Turns out it was as simple as looking at the wrong sheet. There was a sheet named FootMeter that I was looking at trying to find these cell values. The sheet I was supposed to be looking at of course was Foot-Meter which was a hidden sheet. Guess someone was trying to be secretive with their formula and they had me fooled!

    Anyways I was able to find the formulas I wanted, now I just need to find out why they did what they did! Thanks for all the help

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Name Manager Question

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Name manager
    By colddeck84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2017, 10:41 AM
  2. [SOLVED] Global array (that name manager thing) question
    By WereElf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2017, 10:21 AM
  3. [SOLVED] Analysis - Scenario Manager question
    By Exequiel3k in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-10-2016, 03:03 PM
  4. Analysis - Scenario Manager question
    By Exequiel3k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2016, 07:33 AM
  5. sales manager & purchase manager sheets command button error
    By rana19 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-24-2016, 07:26 AM
  6. Replies: 3
    Last Post: 04-03-2008, 03:16 PM
  7. scenario manager programming question
    By daizy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2005, 12:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1