View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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