• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

add sheet in the activeworkbook

Dalia

Member
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
 
Back
Top