D dfrancefort May 18, 2004 #1 I need to process worksheets in a workbook. Is there a way to loop through all of the worksheet names in an open workbook?
I need to process worksheets in a workbook. Is there a way to loop through all of the worksheet names in an open workbook?
P pfsardella May 18, 2004 #2 Dim wSht as Worksheet For Each wSht in ActiveWorkbook.Worksheets ' Your processing code here. Next wSht HTH Paul
Dim wSht as Worksheet For Each wSht in ActiveWorkbook.Worksheets ' Your processing code here. Next wSht HTH Paul
