Use macro to delete worksheet without specific name Eg:Sheet 1

[Delight]

Hello Everybody,

Need help again !! I need a macro to delete active worksheets without a
specific
worksheet name eg: Sheet7, Sheet8 & Sheet9, etc. I had tried this statement
but it don't work.. Is there anyone can help me ??

Activesheet.Delete

Thank You Very Much !!!

 

[Bob Phillips]

Why and how doesn't it work?

 

[Gary''s Student]

Sub JustKillMe()
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
End Sub

 

[Gary''s Student]

Hi Simon;

That is an interesting interpretation of the question.

 

[Delight]

Hello Everybody,

Thanks for the help !! Simon, I followed your method and I get what I want.

Thanks !!