| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy fixed range of multiple sheets into new workbook
Norman,
The first macro you wrote, works perfectly each time. It copies the sheets and puts it in the destWB. The second still gives an error and in my opinion tries to put the copied sheets into the srcWB Perhaps it's an idea to work out the first macro in which the sheets are copied in fixed value and format. I know I maybe asking much, but as I am not that familiar with VB, your a hope for me :) thankx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy chart between multiple sheets in workbook | Charts and Charting in Excel | |||
| Copy cell (C6) from multiple sheets in a wbook to another workbook | Excel Programming | |||
| Copy cell (C6) from multiple sheets in a wbook to another workbook | Excel Programming | |||
| How do I copy print formatting to multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
| copy data in one sheet to multiple sheets in same workbook | Excel Worksheet Functions | |||
Hybrid Mode
