Copying Excel Cells including Names Into Existing Spreadsheet
 

I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and
not to the sheet itself. I have somehow lost the cell names on the new
revision and need them in order to run the VBA code.

Is it possible to paste the old sheet onto the new one keeping the cell names?

Copying Excel Cells including Names Into Existing Spreadsheet
 

MonkeyHanger

Why not right click on the worksheet tab you want to copy and from the menu
select "copy or move", then follow the questions and move it (or a copy) to
the other workbook? This will move named ranges, macros, formating, etc. It
moves it all or a true "copy" of your worksheet.

Mike Rogers



"MonkeyHanger" wrote:

I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and
not to the sheet itself. I have somehow lost the cell names on the new
revision and need them in order to run the VBA code.

Is it possible to paste the old sheet onto the new one keeping the cell names?

Copying Excel Cells including Names Into Existing Spreadsheet
 

Thanks for your reply, however this does not help. If I paste the sheet in, I
loose all names of cells.

"Mooloolaba44" wrote:

I'm sure that you can do this via paste special function

"MonkeyHanger" wrote:

I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and
not to the sheet itself. I have somehow lost the cell names on the new
revision and need them in order to run the VBA code.

Is it possible to paste the old sheet onto the new one keeping the cell names?

Copying Excel Cells including Names Into Existing Spreadsheet
 

I'm sure that you can do this via paste special function

"MonkeyHanger" wrote:

I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and
not to the sheet itself. I have somehow lost the cell names on the new
revision and need them in order to run the VBA code.

Is it possible to paste the old sheet onto the new one keeping the cell names?