Duplicated range names
 

Hi everyone,

I've just named a range of cells on a worksheet. Then I created a copy of
the worksheet in the workbook and now i've got two ranges of cells with the
same name.

I didn't think you could do that.

So now when I select my range from the Names drop down list it takes me to
the original range of cells, unless i am on the copied sheet, in which case
it takes me to the range on that sheet.

Is this normal? I am using Excel 2002.

TIA
big t

Duplicated range names
 

You have created a local name, one that applies just to that worksheet.

Select that worksheet, and go to InsertNamesDefine..., and delete it. You
will know it because the sheet name will be in the list as well, to the
right.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"big t" wrote in message
...
Hi everyone,

I've just named a range of cells on a worksheet. Then I created a copy of
the worksheet in the workbook and now i've got two ranges of cells with
the
same name.

I didn't think you could do that.

So now when I select my range from the Names drop down list it takes me to
the original range of cells, unless i am on the copied sheet, in which
case
it takes me to the range on that sheet.

Is this normal? I am using Excel 2002.

TIA
big t

Duplicated range names
 

thanks Bob. I really thought Excel would have prevented this from happening.

cheers
big t


"Bob Phillips" wrote:

You have created a local name, one that applies just to that worksheet.

Select that worksheet, and go to InsertNamesDefine..., and delete it. You
will know it because the sheet name will be in the list as well, to the
right.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"big t" wrote in message
...
Hi everyone,

I've just named a range of cells on a worksheet. Then I created a copy of
the worksheet in the workbook and now i've got two ranges of cells with
the
same name.

I didn't think you could do that.

So now when I select my range from the Names drop down list it takes me to
the original range of cells, unless i am on the copied sheet, in which
case
it takes me to the range on that sheet.

Is this normal? I am using Excel 2002.

TIA
big t

Duplicated range names
 

Excel allows you to do this, so you could use the same name on each sheet.
Under some situations, it makes life a lot simpler.

big t wrote:

thanks Bob. I really thought Excel would have prevented this from happening.

cheers
big t

"Bob Phillips" wrote:

You have created a local name, one that applies just to that worksheet.

Select that worksheet, and go to InsertNamesDefine..., and delete it. You
will know it because the sheet name will be in the list as well, to the
right.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"big t" wrote in message
...
Hi everyone,

I've just named a range of cells on a worksheet. Then I created a copy of
the worksheet in the workbook and now i've got two ranges of cells with
the
same name.

I didn't think you could do that.

So now when I select my range from the Names drop down list it takes me to
the original range of cells, unless i am on the copied sheet, in which
case
it takes me to the range on that sheet.

Is this normal? I am using Excel 2002.

TIA
big t





--

Dave Peterson