Macro for sheet delete, very easy

C

comotoman

my code is:
Sheets("Sheet 1 (2)").Select
ActiveWindow.SelectedSheets.Delete

How can i hace it delete the seleted sheet, not always 'Sheet 1 (2)'?
 
D

Dave O

This code deletes the active sheet, with no prompt for confirmation:

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
 
Top