Named ranges
 

Shawn,

It is very important.

What you are seeing is worksheet names, as against workbook names. A
workbook name applies throughout the workbook, whereas the worksheet name
only applies to that sheet. As you noticed, it means that you can have the
same name referring to different ranges depending upon the sheet that is
active.

You create worksheet names by stipulating the sheet in the name, such as
Sheet1!myName. When you do this, Sheet1 must be active at the time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Shawn" wrote in message
...
Hi

Hi

I just noticed something that was very strange and I need to find out
whether or not this is expected. It looks like multiple named ranges with
exactly the same name can exist in one workbook. This means that different
cells are referenced at different situations if this named range is used in
formulas. My understanding was that range names have to be unique within a
workbook. Which behaviour is expected?

In addition, if you look through the Insert|Name|Define menu option only
one reference shows for a particular duplicated named range.

This may sound like an observation that is not very important but it is
very important for what I'm attempting to do.

Thanks a lot

Shawn