Home Excel VB/VBA Delete all worksheets
20 | 05 | 2012
This site has been updated and renewed. You have followed an old link.

Click here to go to the new site

http://www.visiblevisual.com/jupgrade

Delete all worksheets PDF Print E-mail
User Rating: / 0
PoorBest 
Tutorials

"Deleteallworksheets"

View source
 
 
 
 
	Sub DeleteAllWorkSheets(Byval wrkbk as Workbook)
 
 
 
	Dim I As Integer
 
 
 
	Application.ScreenUpdating = False
 
	Application.DisplayAlerts = False
 
 
 
	For I = wrkbk .Worksheets.Count To 1 Step -1
 
	If wrkbk (I).Name <> "Sheet1" Then wrkbk (I).Delete
 
	Next I
 
 
 
	Application.ScreenUpdating = True
 
	Application.DisplayAlerts = True
 
 
 
	 End Sub

 

Add comment


Security code
Refresh

This site has been updated and renewed. You have followed an old link.

Click here to go to the new site

http://www.visiblevisual.com/jupgrade