Delete worksheet using VBA
Deleting a worksheet using VBA can be simple...
Dim ws As Worksheet: Set ws = ws.Delete
The problem with this code is that the process gets interupted by a confirmation prompt, which may not be what you want.
Delete worksheet without confirmation prompt
The code below uses
Application.DisplayAlerts = False to prevent the warning. Don't forget to set DisplayAlerts to True again.
Dim ws As Worksheet: Set ws = Application.DisplayAlerts = False ws.Delete Application.DisplayAlerts = True