Read Range SheetName indexing


#1

Is there a way to loop through all the sheets in an excel workbook without indexing them through there names?


#2

Found the answer to my question.

Using the output workbook variable in the application scope, there is a method is the workbookaplication variable type called .GetSheets(x) where x is the sheet number.


#3

You are right GetSheet(x) works.