VBA code for going to the First Worksheet - Excel Mac 365

[ExcelBeginner445]

Is there a Macro that can be made to go to the first worksheet in an excel file - regardless of the name of the worksheet

I am not a programmer and do not understand anything about Visual Basics. I was hoping to find some VBA Code that I can paste into the VBA Editor in order to do this.

 

[Fluff]

Hi & welcome to MrExcel.
Try
Sub GotoSheet()
Sheets(1).Activate
End Sub

 

[ExcelBeginner445]

Thank you very much for the help!

I find that this may not work if the first worksheet was since deleted (e.g. if I delete worksheet 1 and now worksheet 2 is my first worksheet - ie the worksheet furthest to the left).

Is there a way around this?

 

[Fluff]

The code should always take you the first sheet in the workbook (from left to right) regardless if you have deleted any

 

[ExcelBeginner445]

Yes it is working perfectly. Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback