ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select / Activate last Sheet (https://www.excelbanter.com/excel-programming/401927-select-activate-last-sheet.html)

Sean

Select / Activate last Sheet
 
What code could I use to select cell A1 in the last sheet? I have
variable quantities of sheets and the sheet names can be changed. So I
guess its something like Worksheets(xxx).Select, but how do I know the
last number?

Thanks

Sean

Select / Activate last Sheet
 
Ok, just spotted an archived post, that does the trick

Dim i As Integer
i = Sheets.Count
Sheets(i).Select

Very clever



All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com