Search notes:

Excel VBA: Worksheet.Delete

The delete method of a worksheet object deletes the worksheet
One might want to set application.displayAlerts to false before deleting a worksheet so that the user is not prompted to confirm the deletion (Message Box with «Microsoft Excel will permantently delete shis sheet. Do you want to continue?»):
dim ws as worksheet : set ws = sheets("fooBarBaz")
dim da as boolean   : da = application.displayAlerts
application.displayAlerts = false
ws.delete
application.displayAlerts = da

See also

deleteWorksheet() in ExcelHelpers.
The keyboard shortcut alt+h -> d -> s -> enter deletes the current worksheet.

Index