delete
method of a worksheet
object deletes the worksheet 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