Results 1 to 3 of 3

Thread: An Easy One

  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    An Easy One

    How do you make name definitions for different spreadsheets?

    When I Insert/name/define and enter one, it works fine for that sheet...and every sheet after that. That exact same spot regardless of what sheet I am on.
    How do I make these definitions independent of themselves and one sheet alone?

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: An Easy One

    If I understand your question, you're trying to define a Worksheet level name. To do that, you need to prefix your name with "worksheet_name!"(no quotes)
    For example, to define a name of 'TEST' for three different sheets called Sheet1, Sheet2, Sheet3, you'd Insert / Name / Define on Sheet1. The name you type in would be "Sheet1!TEST" the reference would be whatever range you wanted on Sheet1. Then go to Sheet2 and repeat this process except this time you'd type in "Sheet2!TEST" for your name. Repeat for Sheet3. You would now have three different named ranges all with the name TEST but refering to different ranges depending upon which sheet was active.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: An Easy One

    Of course, why not follow the simple naming rules of VBA?
    [img]/w3timages/icons/doh.gif[/img]

    It just goes to show you, learn too much at once and your brain turns into the equivalent of a busy city intersection with a blown out traffic light.
    Thanks Gene-o

Posting Permissions

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