Worksheets.count with exemption

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
If I want to create a new sheet and position it some exact place I use a script like this:
Code:
Sub Make_New_Sheet()
'Modified  7/4/2019  11:44:20 AM  EDT
Sheets.Add(After:=Sheets("Alpha")).Name = "Bravo"
End Sub
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,102,508
Messages
5,487,288
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top