Copying Excel Cells including Names Into Existing Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thanks for your reply, however this does not help. If I paste the sheet in, I
loose all names of cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Spreadsheet with Cell References Into A Different Workbook 1
Excel VBA 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel, assign cells in multiple worksheets from one sheet 1
Using names referencing a cell in another workbook 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy cells in Excel 1

Back
Top