View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Wei Lu [MSFT] Wei Lu [MSFT] is offline
external usenet poster
 
Posts: 70
Default Activate vs Select a sheet

Hello John,

Yes, if you only have 2 sheets, it is no difference.

Sheets("Sheet1").Activate is the same as clicking on the Sheet1 tab with
the mouse.

What's your problem you are facing?

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.