Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. In most cases you can avoid using the worksheet Index property
Sub InsertChartsBeforeWorksheets2()
           Dim myWorksheet As Worksheet
           For Each myWorksheet In Worksheets
           Charts.add Before:=myWorksheet
           Next myWorksheet
     End Sub