| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to control cell references when copying a formula? | Excel Discussion (Misc queries) | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
| copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
| Copying linked cell references. | Excel Worksheet Functions | |||
Linear Mode
