deleting selected worksheets using vb code

G

George

Can anybody tell how do I deleted selected worksheets using vb codes. The
whole code would also include clear contents of a number of cells in Sheet(2)
and deleting all sheets after sheet(2).
Thank you.
 
D

Dave Peterson

Maybe this'll get you started:

Option Explicit
Sub testme()

Dim iCtr As Long

Application.DisplayAlerts = False
For iCtr = Sheets.Count To Sheets("Sheet(2)").Index + 1 Step -1
Sheets(iCtr).Delete
Next iCtr

Worksheets("Sheet(2)").Range("a1:b3,c9,d12:e99").ClearContents

End Sub
 
Top