ExcelBanter - Get sheet by index?

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

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

- - Get sheet by index? (https://www.excelbanter.com/excel-programming/437918-get-sheet-index.html)

Robert Crandal

Get sheet by index?

If I have many sheets in my workbook, how can I get
the index number of the active sheet?? Is there
a property or method for "ActiveSheet" which gives
back this value??

Dave Peterson

Get sheet by index?

msgbox activesheet.index

Robert Crandal wrote:

If I have many sheets in my workbook, how can I get
the index number of the active sheet?? Is there
a property or method for "ActiveSheet" which gives
back this value??

--

Dave Peterson

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