| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formatting
Hi!
I want to copy an entire workbook to a new workbook by using: sourceWorkBook.sheets(arr).Copy After:=NewBook.sheets(3) where arr is an array of worksheet-names, this works fine with one exception - the formatting does not seem to be copied along with the content. How can I achive this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using copy and destination formatting | Excel Discussion (Misc queries) | |||
| Copy formatting, Help | Excel Discussion (Misc queries) | |||
| Is it possible to copy all formatting from one chart to another? | Charts and Charting in Excel | |||
| How do I copy formatting from one worksheet to several others? | Excel Discussion (Misc queries) | |||
| copy font...not formatting | Excel Programming | |||
Threaded Mode
