D Dalia Member May 10, 2015 #1 how to add sheets ion the activeworkbook. the macro code is below Sub addworkbook() Dim ws As Worksheets Dim i As Integer For i = 1 To 6 ActiveWorkbook.Worksheets(i).Add Next i End Sub
how to add sheets ion the activeworkbook. the macro code is below Sub addworkbook() Dim ws As Worksheets Dim i As Integer For i = 1 To 6 ActiveWorkbook.Worksheets(i).Add Next i End Sub