Select Sheet1, then in the names dialog, create a name of Sheet1!myname with
the range it refersto, then select sheet2 and repeat with a name of
Sheet2!myName.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"loopoo" wrote in
message ...

Hi!

Does anyone know how can I create 2 named ranges in Excel that have the
same name and define different ranges on 2 different sheets? They have
to be visible only on that specific sheet when I go to the names list
but not to the entire workbook.

I don't need VBA, I only have to do this one from the Excel menus.

Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile:
http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=495482