View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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