Add A New Worksheet Using Excel VBA

Add a new worksheet named “Mike”…

     Worksheets.Add.Name = "Mike"

Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs…

     Worksheets.Add(Before:=Worksheets(1).Name = "Mike"

Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs…

     Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = "Mike"