Insert an Excel worksheet before a specific sheet

Macro Title:
Chart Sheet Name:
Comment:

'

Sub Insert_Worksheet_Before_a_Specific_Chart_Sheet()
'insert a new worksheet before a chart sheet named Analysis Chart

Worksheets.Add Before:=Charts("Analysis Chart")

End Sub