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

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

Select that worksheet, and go to Insert>Names>Define..., 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" <(E-Mail Removed)> wrote in message
news:31B42DB9-52E3-42A1-B993-(E-Mail Removed)...
> 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
>

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 Insert>Names>Define..., 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" <(E-Mail Removed)> wrote in message
> news:31B42DB9-52E3-42A1-B993-(E-Mail Removed)...
> > 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
> >
>
>
>

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 Insert>Names>Define..., 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" <(E-Mail Removed)> wrote in message
> > news:31B42DB9-52E3-42A1-B993-(E-Mail Removed)...
> > > 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