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

December 2016




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 :

This document entitled « Excel/VBA - A command to select the last Sheet of a workbook » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.