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
Worksheets.Add After:=Worksheets(Worksheets.Count)
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)
One Comment