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