| Home |
| Search |
| Today's Posts |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy tab from one spreadsheet to multiple tabs in another spreadsheet while retaining the targets spreadsheets tab names
We have all learned from this particular exercise.
Newsgroups are great!!! Gord On Thu, 6 Jan 2011 16:39:07 -0600, "Clif McIrvin" wrote: "Gord Dibben" wrote in message .. . Formatting is never copied over with the copy destination method. See if this revised macro does what you want. Adds formatting and columnwidth to the copy. Learned something new today <grin. Thinking about it, I've always used .Paste or .PasteSpecial, not copy destination. Also didn't realize .PasteSpecial could paste column widths. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get range names to Apply across multiple tabs | Excel Worksheet Functions | |||
| Allow multiple rows of worksheet tabs for complex spreadsheets | Excel Discussion (Misc queries) | |||
| Exporting selected tabs multiple times to different file names | Excel Programming | |||
| External reference to spreadsheet names (tabs) help needed. | Excel Discussion (Misc queries) | |||
| Macro to copy all spreadsheets into 1 spreadsheet | Excel Programming | |||
![Gord Dibben[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
