Create named ranges

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thanks a lot Bob!

That was simple but I'm not so experienced in Execel.

Chris