View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Activate vs Select a sheet

You can select more than one, but only one can be active.

"John Broderick" wrote:

Hello all,

What is the difference between these two:
Sheets("Sheet1").Activate
Sheets("Sheet1").Select

Thanks,
John