/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 vote325 views1 answer
How to create a c++ templeate
C++
0 vote305 views1 answer
Fast scan in c++
C++
38 votes349 views6 answers
Print hello world in c++
C++
0 vote318 views1 answer
Vector of strings initialization c++
C++
5 votes378 views6 answers
String
C++
0 vote287 views1 answer
How to generate number in c++
C++
4 votes319 views2 answers
Round double to n decimal places c++
C++
0 vote290 views3 answers
C to c++ online converter
C++
1 vote246 views1 answer
How to set environment variable for c++
C++
0 vote320 views2 answers
Comment savoir si un nombre est premier c++
C++