Insert an Excel worksheet before a specific sheet
Macro Title:
|
Worksheet Name:
|
Comment:
' |
Sub Insert_Worksheet_Before_a_Specific_Sheet()
'insert a new worksheet before a sheet named Sheet2
Worksheets.Add Before:=Sheets("Sheet2")
End Sub