Setting a worksheet name with VBA

If you need to add a new sheet with a specific name, try use the following vba code.

Dim ws As Worksheet 'Creates a worksheet object
Set ws = Sheets.Add  'sets worksheet Object to new sheet
ws.Name = "SheetNewName"  'renames sheet