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

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

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.