Excel Worksheets VBA Add Method.

Your options with the Excel Worksheets VBA add method are all Optional and they are...

Before, After, Count, and Type. So...

Worksheets.Add , Worksheets(3), 2, xlWorksheet

would add 2 Worksheets After Sheet3. The first comma is a placeholder. You cannot use both the Before and After parameters in one statement. You're either adding a sheet(s) before a Worksheet or after the active Worksheet.

Worksheets.Add Worksheets(1) , , 2

would add 2 Worksheets Before Sheet1

The Type parameter can be xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. There is one catch though. If you use any type other than xlWorksheet, you would have to use the Sheets object rather than the Worksheets object.

Sheets.Add , , 2, xlChart

would add a chart Worksheet. This is the difference between Sheets and Worksheets objects

Return from Excel Worksheets VBA Add Method to VBA Code Samples

Return to our Homepage