SOLVED

VBA to select the 2nd last added worksheet

Regular Contributor

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 Replies
best response confirmed by hrh_dash (Regular Contributor)
Solution

@hrh_dash 

Use

Sheets(Sheets.Count - 1)

thanks for the help!