VBA to select the 2nd last added worksheet

[hrh_dash]

I would like to have a macro to select the 2nd last added worksheet in the workbook.

I understand that the code below would be selecting the last worksheet in the workbook but would like to have a code to select the 2nd last added worksheet in the workbook.

Sheets(Sheets.Count)

Appreciate the advice and assistance in advance!

[#2 · Accepted solution]

@hrh_dash 

Use

Sheets(Sheets.Count - 1)

[#3]

thanks for the help!