Delete Sheets in Excel
Closed
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
Jul 22, 2009 at 02:38 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 05:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 05:45 AM
Related:
- Delete Sheets in Excel
- Mark sheet in excel - Guide
- Delete my whatsapp account without app - Guide
- Number to words in excel - Guide
- How to open excel sheet in notepad++ - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 22, 2009 at 05:45 AM
Jul 22, 2009 at 05:45 AM
Tha macro is
Sub test() Dim j As Integer, k As Integer Application.DisplayAlerts = False j = Worksheets.Count For k = 1 To j If Worksheets(k).Name = "sheet" Then Worksheets(k).Delete GoTo line1 End If Next k line1: Application.DisplayAlerts = True End Sub