Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Applying names (2003)

    Hi all,
    I've torn my hair out and paced to and fro and I can't work this out <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> . Hoping that one of you brilliant folk can enlighten me...

    My question is...in the Apply Names dialog box (Insert menu, Name, Apply) what does the "Ignore Relative/Absolute" option actually do? I've worked out the "Use row and columns names" option but this other one has defeated me.

    Any advice would be enormously appreciated!
    Thanks
    Megl

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Applying names (2003)

    As follows.

    Say you have a name test that refers to =$B$1
    and a formula somewhere :

    =B1+$B$1

    With "Ignore relative/absolute", you end up with:

    =test+test

    Uncheck that box and you get:

    =B1+test

    In other words. If "Ignore absolute/relative" is checked, any references to a cel that is named are replaced with the name. If it os NOT checked, only those that have the exact same reference type are replaced.

    So if your name refers to =B$1, with the last setting only references matching B$1 exactly are replaced.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Applying names (2003)

    Arh ha. All sorted in my head now. Thanks heaps Jan! <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    Megl

Posting Permissions

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