| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheets from A to B without reference
Hi all,
I know that when you copy a sheet from a workbook to another workbook references to the original cells are built. I have written a marco t remove the references, but it looks stupid. Therefore, is that any wa not to copy the reference to the new workbook? Any help is appreciated -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheets from A to B without reference
Why don't you show us your "stupid" macro? It might then be easier t
correct. Another option is to copy the cells instead of copying the sheet -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell info to other sheets, other sheets dont contain all row. | Excel Worksheet Functions | |||
| move or copy sheets doesn't copy format | Excel Worksheet Functions | |||
| Reference sheets | Excel Worksheet Functions | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
| reference sheets | Excel Programming | |||
![kaon[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
