How to transfer/copy range names with a worksheet to a new Excel f

[DW]

Hello:
I have a large worksheet with about 200 named ranges. I would like to copy
this worksheet and all the range names to other Excel files (workbooks). How
do I do this?

(When I copy the entire worksheet to another file, the range names do not
transfer.)

Thanks, in advance, for your help.

 

[Tyro]

I copy the worksheet in Excel 2007 with:

1) Right click on worksheet's tab, move or copy, new book, check make a
copy. I get all of the names in the new workbook.

2) I select all of the cells in the worksheet by clicking on the area to the
left of the column A header and above the row 1 header. (You can also select
all cells by pressing Ctrl+A once, perhaps twice) I open a new workbook. I
paste. All of the named ranges are there.

I don't know what you're doing

Tyro

 

[Tyro]

In point 2, after selecting all of the cells, I copy, of course, before
pasting

Tyro

 

[Gord Dibben]

How are you doing the copy?

Right-click on the sheet tab and select Move or Copy then checkmark in "Create a
copy" and select the workbook to copy to and OK

Range names go with the copy.


Gord Dibben MS Excel MVP

 

[DW]

Thanks to All:

I have been copying by selecting all the cells in the worksheet by clicking
on the top left corner. Not using the Tab. Using the Tab, as suggested,
works.

Thanks, again.

 

[Tyro]

So does the top left corner. You select all cells by doing that. Then you
copy. Then you paste in the new workbook

Tyro