| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste to a new workbook
I have a button on a userform. When the user clicks said button it
copys the page and pastes it into a new workbook. My dilemma is that it does not format the columns the same as the source. I have tried recording a macro where I select that particular option from the paste menu but it does nto record it in the macro. Suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste to a new workbook
how about just using
activesheet.copy this copies the activesheet to a new workbook. -- Regards, Tom Ogilvy "stewart" wrote: I have a button on a userform. When the user clicks said button it copys the page and pastes it into a new workbook. My dilemma is that it does not format the columns the same as the source. I have tried recording a macro where I select that particular option from the paste menu but it does nto record it in the macro. Suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Linear Mode
