| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sheets to another file
I have a macro which copies several sheets to another file and then deletes
all the sheet code. I now find that there are 2 extra sheets to be copied but the sheet code is required in them. How can I get around this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy sheets to another file
Gareth, As usual you should always post your coding efforts.
"Gareth" wrote in message ... I have a macro which copies several sheets to another file and then deletes all the sheet code. I now find that there are 2 extra sheets to be copied but the sheet code is required in them. How can I get around this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy sheets to another file
Deleting the sheet code is an overt act.
Test for the sheetname and don't delete the code in those sheets? -- Regards, Tom Ogilvy Gareth wrote in message ... I have a macro which copies several sheets to another file and then deletes all the sheet code. I now find that there are 2 extra sheets to be copied but the sheet code is required in them. How can I get around this? |
| 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 | |||
| copy&paste 28 individual files into one file/28 work sheets | Excel Worksheet Functions | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
| 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 | |||
![Gareth[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
