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 |
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