Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Looping through a Collection
Sub DeleteRow1()
    Dim myWorksheet As Worksheet
    For Each myWorksheet In ActiveWorkbook.Worksheets
        myWorksheet.Rows(1).delete
    Next myWorksheet
End Sub