Supress Warning Message

[David Billigmeier]

I have the following code in a macro:

For i = numVars + 1 To 15
Sheets("numVar" & i).Select
ActiveSheet.Delete
Next

It automatically deletes some tabs in my workbook. Every time I run it I
get a warning message asking if I really want to delete each tab. Is there
any code I can place before I run this loop to supress these warning messages?

Thanks.

 

[sonu]

use this at the begning of your code

Application.DisplayAlerts = False

 

[Alok]

Try this

Application.DisplayAlerts = False