Insert same name range on different workwheets
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Insert same name range on different workwheets

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Rhode Island
    Posts
    141
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have had this question answered before on the old message board, but I can't seem to get through the archives without getting an illegal message error and I can't rermember how to do this.
    I have a workbook with a sheet for each day of the week. I need to use the same name range on each page of the workook. How can I do this?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-03 03:18, LoriD wrote:
    I have had this question answered before on the old message board, but I can't seem to get through the archives without getting an illegal message error and I can't rermember how to do this.
    I have a workbook with a sheet for each day of the week. I need to use the same name range on each page of the workook. How can I do this?
    Select your range
    In the Name drop down list type in the name for this range.



    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Rhode Island
    Posts
    141
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's not working. Each time I go to one of the other spreadsheets and try to go to the range, it keeps bringing me back to the range in the Monday page.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You wrote.

    On 2002-04-03 03:18, LoriD wrote:
    I have had this question answered before on the old message board, but I can't seem to get through the archives without getting an illegal message error and I can't rermember how to do this.
    I have a workbook with a sheet for each day of the week. I need to use the same name range on each page of the workook. How can I do this?
    And

    On 2002-04-03 05:04, LoriD wrote:
    It's not working. Each time I go to one of the other spreadsheets and try to go to the range, it keeps bringing me back to the range in the Monday page.
    1) you can't have two ranges with the same name. (well you can, Excel just won't see both)
    Naming a range references the Range NOT necessarily the sheet it's on.

    2) the only reason I can think of wanting use the same Named Range is you want the same list, is this NOT what you need?
    "Have a good time......all the time"
    Ian Mac

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com