New Sheet naming

charlesdh · #1 09-23-2015, 11:02 AM

Hi,

Here's a simple code to add and name a worksheet also delete the named worksheet.
Place this code in a module. Test on sample sheet ony.

Code:

Sub AddWorksheet()
Application.DisplayAlerts = False'' this will prevent warning about deleting the sheet
Sheets("Your sheet name").Delete
Application.DisplayAlerts = True ''this will reset the warning

Worksheets.Add().Name = "MySheet"''' change "MySheet to the name you want

End Sub

FenelonPaul · #2 09-24-2015, 07:57 AM

Thanks, Charles.. that works perfectly for me!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Batch re-naming	twols26	Word VBA	7	06-16-2015 12:29 PM
Populate sheet 3 with data from sheet 1 and sheet 2	speck	Excel Programming	0	01-14-2015 07:54 AM
Naming Cells for formula referencing	lynchbro	Excel	6	06-26-2014 07:45 AM
re-naming arrays in VBA?	JDevsFan	Excel Programming	4	03-15-2012 08:44 AM
Auto file naming	Rong Peng	Word VBA	0	07-29-2011 07:37 AM