Possible to Import/Export "Named range" into/to another Excel filr?

[pcvchriskmg]

Good Afternoon,

I am working in Excel 2010 on a Windows 7 machine.

I have various "Named Ranges" that I am using in file A. The ranges are actually stored in a separate, common file. I also need to access the same ranges for use in file B. Rather than going through the process of naming a new range for file B, can I somehow import the named ranged from file A into file B?

Here is an example if I'm not being clear.

File A has named range "Colors" which consists of cells A1:A10 in file C.
File B also needs to access cells A1:A10 in file C.

Can I somehow import "Colors" into the Name Manager in file B? Or do I need to go through the process of creating a separate named range in file B?

Thanks!
Chris

 

[cyrilbrd]

Hi,

same workbook, you obviously can't
different workbook: read this thread.

If this useful?

 

[pcvchriskmg]

Hi,

same workbook, you obviously can't
different workbook: read this thread.

If this useful?

Yes, this thread has helped me out a lot. My VBA is a little weak but I'm almost there.

Thanks cyrilbrd!

 

[cyrilbrd]

You are most welcome.

Glad it helped.