| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save to sheet 2 in workbook
The result of my macro needs to be saved to sheet 2 of the same workbook, BUT
I cannot figure out how to do this. I can save it as another file in My documents but really want to put it on sheet 2. Any help will be appreciated. -- Al |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save to sheet 2 in workbook
would this work for you?
Sheets("Sheet2").Select Range("A1").Select -- Gary "AMK" wrote in message ... The result of my macro needs to be saved to sheet 2 of the same workbook, BUT I cannot figure out how to do this. I can save it as another file in My documents but really want to put it on sheet 2. Any help will be appreciated. -- Al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help! When I 'save changes' to my workbook/sheet | Excel Discussion (Misc queries) | |||
| Save Sheet as Workbook | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Can I only save one sheet out of the workbook? | Excel Discussion (Misc queries) | |||
| Save sheet as .TXT out of Workbook | Excel Programming | |||
Linear Mode
