/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

0 vote136 views7 answers
Online converter c++ to c
C++
0 vote136 views1 answer
The smallest element from three
C++
8 votes135 views3 answers
Min in c++
C++
1 vote143 views1 answer
C++ power
C++
1 vote141 views1 answer
Get a string from file in c++
C++
0 vote132 views1 answer
How to check sqrt of number is integer c++
C++
9 votes158 views3 answers
Max function in c++
C++
1 vote143 views1 answer
Ifstream relative file path
C++
0 vote135 views1 answer
Left margin c++
C++
0 vote169 views1 answer
Curl upload folder and subfolders
C++