Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Named Ranges (Excel 2000 or 2003)

    Hi all, Again I'm stuck ...

    Here's my issue now ....
    I can have more than one DoseSolnConc named range in a workbook, they are on separate worksheets, however.
    (Dose Solt 1, Dose Solt 2, Dose Solt 3, ... Dose Solt N -- each has a DoseSolnConc named range)

    Now, in a different sheet, ... I wish to use the appropriate Named Range, so ...
    G8 = Name of Sheet to Use in Formula (e.g. Dose Solt 1, Dose Solt 2, ... )
    E13 = Just a number

    In another cell I have this formula,
    J13 = ROUND(DoseSolnConc*E13,0)

    How can I, within Excel, modify the formula so that it will know which DoseSolnConc to get.
    I actually need to place the formula in cell J13 using VBA, but the formula needs to stand-alone within the sheet so that the user can modify G8 (the name of the appropriate sheet to use).

    Again, any help is dearly appreciated ...
    Thanks,
    --cat

    (It would help if I had "help" installed at home!!!)

  2. #2
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Named Ranges (Excel 2000 or 2003)

    Don't worry about this one, please. I have figured another way to do the same thing ...

    Thanks,
    --cat

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Named Ranges (Excel 2000 or 2003)

    Hi Cindy,

    A good help on named ranges can be found here:

    http://bmsltd.ie/MVP/Default.htm and then look for Jan Karel Pieterse's NameManager.zip

    Regards, Teunis

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Multiple Named Ranges (Excel 2000 or 2003)

    Hi,

    To do what you want and have a set of worksheets each with the same Range Names, include the Worksheet name with the Range name when it is defined.

    Instead of defining a Range Name as "MyRange" define it as "Sheet1!MyRange".

    Good Luck!

    Peter Moran

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

    Re: Multiple Named Ranges (Excel 2000 or 2003)

    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
  •