Copying Defined Names
 

Greetings:

When using Excel 2003, how do I copy or move (or otherwise get) defined
names from one workbook to another intact? When I copy (or move) a sheet
from one workbook to another, the defined names go with it, but the defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this often
and I have a great many defined names that I need to keep. (The sheets
have identical names in both workbooks).

Thank you,
JP

Copying Defined Names
 

"JP" wrote in message
. 97.136...
Greetings:

When using Excel 2003, how do I copy or move (or otherwise get) defined
names from one workbook to another intact? When I copy (or move) a sheet
from one workbook to another, the defined names go with it, but the
defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this often
and I have a great many defined names that I need to keep. (The sheets
have identical names in both workbooks).

Thank you,
JP

If you want to move defined names, you really should create them in a macro.
The macro can then easily be moved.

/Fredrik

Copying Defined Names
 

"Fredrik Wahlgren" wrote in
:


"JP" wrote in message
. 97.136...
Greetings:

When using Excel 2003, how do I copy or move (or otherwise get)
defined names from one workbook to another intact? When I copy (or
move) a sheet from one workbook to another, the defined names go with
it, but the
defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this
often and I have a great many defined names that I need to keep.
(The sheets have identical names in both workbooks).

Thank you,
JP

If you want to move defined names, you really should create them in a
macro. The macro can then easily be moved.

/Fredrik



Well, sure, I didn't think of that. I'll try it that way.

Thanks and best regards,
JP