Define name Q
 

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

Define name Q
 

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

Define name Q
 

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

Define name Q
 

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