+ Reply to Thread
Results 1 to 3 of 3

create named range specific to worksheet

  1. #1
    beliavsky@aol.com
    Guest

    create named range specific to worksheet

    Suppose I have a named range "x" in cell A1 of worksheet Sheet1, and I
    copy the contents of Sheet1 to Sheet2. When I then write a formula on
    Sheet2, "x" still refers to Sheet1!A1, when I want it to refer to
    Sheet2!A2. In other words, I want each sheet copied from Sheet1 to have
    its own set of named ranges, defined on that sheet. Can this be done?
    Thanks.


  2. #2
    Tom Ogilvy
    Guest

    Re: create named range specific to worksheet

    Worksheets("Sheet2").Range("A1").Name = "Sheet2!X"

    creates a sheet level name of X
    --
    Regards,
    Tom Ogilvy

    <beliavsky@aol.com> wrote in message
    news:1119971511.655834.254040@g49g2000cwa.googlegroups.com...
    > Suppose I have a named range "x" in cell A1 of worksheet Sheet1, and I
    > copy the contents of Sheet1 to Sheet2. When I then write a formula on
    > Sheet2, "x" still refers to Sheet1!A1, when I want it to refer to
    > Sheet2!A2. In other words, I want each sheet copied from Sheet1 to have
    > its own set of named ranges, defined on that sheet. Can this be done?
    > Thanks.
    >




  3. #3
    Roman
    Guest

    Re: create named range specific to worksheet

    Sub makename()
    ActiveSheet.Range("a1").Name = ActiveSheet.Name & "X"
    End Sub

    This is universal for all sheets. Unfortunately for you it is not
    possible to have two or more ranges with same name within one workbook.
    You can solve this by replacing e.g. sheet1x by sheet2x in your
    formulas afer copying.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1