Insert an Excel worksheet before the last sheet

Parameters

Macro Title:
Worksheet Name:
Comment:

'

Sub Insert_Worksheet_Before_the_Last_Worksheet()
'insert a new worksheet before the last worksheet

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

End Sub