Hi,

You can do this is Excel 2007 by selecting the scope of the name as
worksheet or workbook.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"tabell88" wrote in message
...
How do I name a range the same thing in multiple worksheets so I can
reference the named range in each of the worksheets in a totally different
worksheet. For example I have a range named as "sales" in worksheet 1,
but
I can't name it the same thing in worksheet 2 otherwise is seems to
overwrite
the first one. Then I can only reference the one named range in my third
worksheet.