software






 

Question by  Ellen24 (-5)

What is the process of adding a vba dummy sheet?

I need to add a vba dummy sheet to my files.

 
+4

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.

 
+2

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

 
You have 50 words left!