Copying Spreadsheet with Cell References Into A Different Workbook

  • 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?
 
Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It has the ability to pick up names and reapply them to different workbooks.
 

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 Excel Cells including Names Into Existing Spreadsheet 3
Highlight changes within cell 1
Automatically Copy formatting (I.E. shading) 2
Sharing workbooks limitations - Merged Cells 12
Merge Multiple workbook sheets into one workbook 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Reference Column of Named Cell vba 6
Highlight Changes within cell 1

Back
Top