If the workbooks are identical, why not select all cells, copy and paste
special (formulas), into the new workbook.

"Tom Perlman" wrote:

I have a series of workbooks (6) that feed into a summary book. All workbooks
are identical. I have added alot of named ranges into workbook #1 and would
like to know if there is a way to import or copy the range names into the
other workbooks.