Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sheet Based Range Names (Excel 2000)

    Morning All <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    I've used range names for a while now and sometimes noticed that some range names are related to specific sheets. In particular, the Print_Area is shown with a sheet name.

    What I want to do is assign a particular cell a certain range name that is only valid for that sheet. If I change sheets, then the range name points to a different cell. Then, in a macro, I can use that range name and know that I am getting the value from the cell for that sheet.

    The question is, how do I create one of these range names that are sheet dependent?

    Cheers,

    Tim
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

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

    Re: Sheet Based Range Names (Excel 2000)

    You make a defined name sheet-specific by preceding the name with the name of the sheet when you define the name:

    'Name Of Sheet'!YourDefinedName
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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