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 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 05:45 AM
venkat1926 Posts 1864 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
- Excel date format dd.mm.yyyy - Guide
- How to delete whatsapp contact not in address book - Guide
- Number to words in excel - Guide
- How to copy data from one sheet to another in excel automatically - Guide
- Screenshot in excel - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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