"Jim Rech" wrote in message
...
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



Thanks Jim I appreciate it.

I knew there must be a way but after 3 hours scanning
the help files and tearing my hair out I coulldnt find it.

Keith