ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save to sheet 2 in workbook (https://www.excelbanter.com/excel-programming/332351-save-sheet-2-workbook.html)

Amk

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

Gary Keramidas[_2_]

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





All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com