I have 2 worksheets with numerous named ranges. Each sheet uses the same
names, but I don't think they are 3D, because the Refers To box only shows
the worksheet name I an on. I am unable to duplicate this.. when I try to
make 2 named ranges with the same name in 2 different worksheets, it takes me
back to the first named range.

Any help on how this was set up?

TIA

Check out the "Local Name" section in this link:

http://support.microsoft.com/?kbid=274504

"Benjamin" wrote in message
...
I have 2 worksheets with numerous named ranges. Each sheet uses the same
names, but I don't think they are 3D, because the Refers To box only shows
the worksheet name I an on. I am unable to duplicate this.. when I try to
make 2 named ranges with the same name in 2 different worksheets, it takes
me
back to the first named range.

Any help on how this was set up?

TIA

It's coming back to me now.. Thanks for the help.

"Shatin" wrote:

Check out the "Local Name" section in this link:

http://support.microsoft.com/?kbid=274504

"Benjamin" wrote in message
...
I have 2 worksheets with numerous named ranges. Each sheet uses the same
names, but I don't think they are 3D, because the Refers To box only shows
the worksheet name I an on. I am unable to duplicate this.. when I try to
make 2 named ranges with the same name in 2 different worksheets, it takes
me
back to the first named range.

Any help on how this was set up?

TIA

When you give the name a name (yeah I know), make sure that you also prefix
that with the appropriate sheet name.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Benjamin" wrote in message
...
I have 2 worksheets with numerous named ranges. Each sheet uses the same
names, but I don't think they are 3D, because the Refers To box only shows
the worksheet name I an on. I am unable to duplicate this.. when I try to
make 2 named ranges with the same name in 2 different worksheets, it takes
me
back to the first named range.

Any help on how this was set up?

TIA