Copying Excel Cells including Names Into Existing Spreadsheet

M

MonkeyHanger

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?
 
M

Mike Rogers

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
 
M

MonkeyHanger

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