Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Use for loop to loop through all worksheets

Sub macro_loop4()   Dim i   For i = 1 To ThisWorkbook.Worksheets.Count     Debug.Print ThisWorkbook.Worksheets(i).Name   Next i End Sub