What is the VBA code to select last sheet in workbook

What is the VBA code to select last sheet in workbook

It is possible to select the last sheet of the workbook in Microsoft Excel even if you do not remember the sheet name, or if you don't want the selection to be reliant on the sheet name, and adapt to any changes to the sheets. Here is how you can do it.

To access the last sheet of the workbook without using the name of the sheet, use of this command:

Sheets(Sheets.Count).Select

Need more help with Excel? Check out our forum!
Subject Replies
Unable to change date format in Excel 39
How to calculate positions (1st,2nd,3rd...) in Excel 6
Copying data from one Excel sheet to another. 30
Excel - IF function with multiple words 14
Convert number to spelling 28
How to convert number into text in Excel 9
Date formatting in dd/mm/yyyy 11
Automatically transfer data from one sheet to another 22
If a cell contains any text then add a value 20
Comparing two columns of names in Excel 8
Around the same subject

Excel