What you want to do is called creating a local name. In the Define Name
dialog precede the name with the active sheet's name:

Sheet1!MyName



--
Jim Rech
Excel MVP