Copying Defined Names

[JP]

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

[Fredrik Wahlgren]

"JP" <[email protected]> wrote in message
news:[email protected]...
> 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

[JP]

"Fredrik Wahlgren" <[email protected]> wrote in
news:[email protected]:

>
> "JP" <[email protected]> wrote in message
> news:[email protected]...
>> 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