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

April 2018




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 
Published by jak58. Latest update on November 7, 2012 at 10:18 AM by deri58.
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 (https://ccm.net/).
Excel - Changing the highlighting color of selected cells
VBA - Count the number of colored cells