/C++/Excel vba delete worksheet if exists

Excel vba delete worksheet if exists

For Each ws In Worksheets
    If ws.Name = "asdf" Then
        Application.DisplayAlerts = False
        Sheets("asdf").Delete
        Application.DisplayAlerts = True
    End If
Next

Sheets.Add(After:=Sheets(Sheets.count)).Name = "asdf"

Source: stackoverflow.com

Similar codes

18 votes233 views5 answers
How to clear console c++
C++
7 votes233 views3 answers
C++ get data type
C++
0 vote225 views1 answer
Find subarray sum in c++
C++
8 votes223 views2 answers
Built in factorial function in c++
C++
0 vote234 views1 answer
Cpp get keystroke in console only
C++
3 votes217 views2 answers
Infinity c++
C++
4 votes217 views3 answers
C++ how to get maximum value
C++
0 vote219 views1 answer
Pointers mcq sanfoundry
C++
3 votes230 views5 answers
Combine two vectors c++
C++
2 votes230 views1 answer
How to delete a node c++
C++