Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. For Each-Next is useful for cycling through each member of a collection
Sub Test()
    For Each Item In ActiveWorkbook.Sheets
        Debug.Print Item.name
    Next Item
End Sub