How Do I Create A New Sheet Using Vba In Excel

See more:

VBA

Please I have been working on creating a new sheet using VBA in excel workbook.. please kindly help as i have the script to do that but doesnt know how to work through it.

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Sub TestSheetCreate()
    Dim mySheetName As String, mySheetNameTest As String
    mySheetName = "Sheet7"

    On Error Resume Next
    mySheetNameTest = Worksheets(mySheetName).Name
    If Err.Number = 0 Then
        MsgBox "The sheet named ''" & mySheetName & "'' DOES exist in this workbook."
    Else
        Err.Clear
        Worksheets.Add.Name = mySheetName
        MsgBox "The sheet named ''" & mySheetName & "'' did not exist in this workbook but it has been created now."
    End If
End Sub