vba help goto sheet

[RickeyS]

Hi,
How do you write a statement to goto a sheet? I have a macro that works the way I want (it hides some sheets and makes other sheets visible) but I want a certain sheet to be active at the end of the macro. How do I write that statement to make a certain sheet the active sheet?

Thanks
Rick

 

[RickeyS]

Never mind I figured it out.

Sheets("mysheet").Select

Thanks
Rick

 

[Legacy 51064]

You don't need to select

Sheets("mysheet").Activate

 

[RickeyS]

Is one better than the other? Both work.

Thanks
Rick