ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to select the active sheet? (https://www.excelbanter.com/excel-worksheet-functions/153277-how-select-active-sheet.html)

Eric

How to select the active sheet?
 
After I run a macro, I would like to set the spreadsheet "Summary" as an last
active sheet. Does anyone have any suggestions on how to code it?
Thank for any suggestions
Eric

bj

How to select the active sheet?
 
as the last line in the macro
sheets("Summary").select

"Eric" wrote:

After I run a macro, I would like to set the spreadsheet "Summary" as an last
active sheet. Does anyone have any suggestions on how to code it?
Thank for any suggestions
Eric



All times are GMT +1. The time now is 09:49 PM.

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