| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Needed copying a worksheet to new workbook
Hi I seem to have forgot how to do this. I need to copy 1 worksheet to a
new workbook and can't find anything in Help! Regards Neil *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help Needed copying a worksheet to new workbook
Right click the worksheet tab and you will get a drop down menu to copy it to
a new workbook. -- David "Neil Atkinson" wrote: Hi I seem to have forgot how to do this. I need to copy 1 worksheet to a new workbook and can't find anything in Help! Regards Neil *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help Needed copying a worksheet to new workbook
The following should work. You may be able to leave out both the activate
and select options in which case you wouldn't need the with/end with statement either. With Sheets("Sheet Name") .Activate .Select .Copy End With "Neil Atkinson" wrote: Hi I seem to have forgot how to do this. I need to copy 1 worksheet to a new workbook and can't find anything in Help! Regards Neil *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying worksheet to another workbook | Excel Worksheet Functions | |||
| Copying a worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| Copying worksheet from workbook to another | Excel Worksheet Functions | |||
| Copying worksheet to another workbook | Excel Programming | |||
Linear Mode
