You could use Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

digicat wrote:

Looking for a way to define a name over several Sheets that will apply
to the active sheet only.
An example:
On Sheet1, Sheet2 and Sheet3 in cells A4:G17 I have a form that I want
to give one name (e.g. OrderForm) that will automatically apply to
that area on the active sheet only.

I tried:
=SHEET1:Sheet3!$A$4:$G$17
but the following problems occur:

- the defined name “OrderForm” does not appear in the Name Box
so how can I use it?
- F3 (Paste Name Dialog Box) and Ctrl+F3 (Define Name Dialog Box)
doesn’t help either

Anybody who can put me on the right track?

--
digicat
------------------------------------------------------------------------
digicat's Profile: http://www.excelforum.com/member.php...o&userid=14920
View this thread: http://www.excelforum.com/showthread...hreadid=502825

--

Dave Peterson