ExcelBanter - Select sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select sheet (https://www.excelbanter.com/excel-programming/287900-select-sheet.html)

smi

Select sheet

Please help,
What is the command for select the sheet before last sheet? I am using Excel
97 with WIN 95.
Thank you for your time.

Long

John Wilson

Select sheet

Long,

sheets(sheets.count -1).select

John

"smi" wrote in message
...
Please help,
What is the command for select the sheet before last sheet? I am using
Excel
97 with WIN 95.
Thank you for your time.

Long

smi

Select sheet

Thank you John.

"John Wilson" wrote in message
...
Long,

sheets(sheets.count -1).select

John

"smi" wrote in message
...
Please help,
What is the command for select the sheet before last sheet? I am using
Excel
97 with WIN 95.
Thank you for your time.

Long

All times are GMT +1. The time now is 05:08 AM.