Tutorial - Excel Macro Create new sheet

Описание: In this video we outline how you can use a macro or VBA code to insert a new sheet into Microsoft Excel.

If you are a beginner or new to Excel Macros then please follow the guide below that will get you up to speed to be able to follow this tutorial.

http://twoperscent.com/index.php/exce...

For the written guide to how to perform this then please visit.

http://twoperscent.com/index.php/2017...

The code that we used in this tutorial is as follows.

Private Sub CommandButton1_Click()

ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count)

End Sub

I hope this has helped you.