What is the process of adding a vba dummy sheet?

Answer by  gigo (1706)

To do that you can go over the ActiveWorkbook object. The ActiveWorkbook object has the subobject Worksheets. Over the Worksheets object you can use the add function to create a new dummy sheet.

Answer by  ArunVivek (143)

If you want to add new sheet one space before the last sheet. Name the current sheet as "X1Sheet" and have it become the active sheet, you would use some code like shown below: Sub AddWorksheet() Worksheets. Add(). Name = "X1Sheet" End Sub