/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

1 vote143 views1 answer
Creator of C++
C++
0 vote214 views1 answer
Solve diamond inheritance c++
C++
0 vote153 views1 answer
Unique_ptr syntax
C++
1 vote140 views1 answer
Cuda dim3
C++
0 vote137 views1 answer
C++ how to do a pointer char to take varols from keyboard
C++
5 votes133 views4 answers
Split pdf
C++
1 vote143 views2 answers
C++ get last element in array
C++
0 vote128 views2 answers
C++ program to convert celsius to fahrenheit
C++
1 vote178 views1 answer
Eosio name to string
C++
1 vote146 views1 answer
Optimized Bubble Sort
C++