Excel/VBA - A command to select the last Sheet of a workbook

March 2017




Issue


How to select the last sheet of my workbook without using the specific sheet name..etc?

Solution

  • To access the last sheet of the workbook, use of this command:

Sheets(Sheets.Count).Select 

Related


Published by jak58.
This document, titled "Excel/VBA - A command to select the last Sheet of a workbook," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).