Adding New Worksheets in VBA(Hindi)

Adding New Worksheets in VBA(Hindi)

Sub AddSheet()

  Worksheets.Add

End Sub

Sub RenameSheet()

'   Worksheets("Sheet2").Name = "dummy"

' Worksheets(2).Name = "mySheet"

Worksheets(1).Name = VBA.InputBox(Prompt:="Please enter sheet name", Title:="Rename Sheet")

End Sub

Sub AddMultiSheets()

   Worksheets.Add Count:=4

End Sub

Sub AddSheetInLast()

'  Worksheets.Add After:=Worksheets("mySheet")

Worksheets.Add After:=Worksheets(Worksheets.Count)

  'Debug.Print Worksheets.Count

End Sub

Sub AddsheetInStart()

   Worksheets.Add Before:=Worksheets(3)

End Sub

Sub AddMacroChart()

' Sheets.Add Type:=2

'  Sheets.Add Type:=3

  Sheets.Add Type:=1

End Sub