VBA Code To Add New Sheet

Complete Excel VBA Course

In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet at the end of Excel file

VBA Code To Add New Sheet at the end of file:

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

VBA Code To Add New Sheet at the beginning of file:

If you want to add the new worksheet at the beginning of the file, you can use the below code

Worksheets.Add Before:=Worksheets(1)
VBA Code To Add New Sheet ​

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.

Recommended Articles

Similar Posts

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *