![]() |
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 |
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