Forum Discussion

hrh_dash's avatar
hrh_dash
Iron Contributor
Sep 03, 2022
Solved

VBA to select the 2nd last added worksheet

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!

 

 

Resources