Copying Spreadsheet with Cell References Into A Different Workbook
 

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 Spreadsheet with Cell References Into A Different Workbook
 

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.

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?

--

Dave Peterson