title: Check if sheet exists, if not create -VBA
body: <p>I have test many codes which check if a sheet exists (based on name) and if not create one. Some of them loop all sheets and some refer to sheet and if create an error means that sheet does not exist. Which is the most appropriate - orthodox - faster way achieve this task?</p>
  <p>Currently I'm using:</p>
  <pre><code>Option Explicit
  
  Sub test()     
      Dim ws As Worksheet
      Dim SheetName As String
      Dim SheetExists As Boolean
      
      SheetName = &quot;Test&quot;
      SheetExists = False
      
      With ThisWorkbook
          'Check if the Sheet exists
          For Each ws In .Worksheets
              If ws.Name = SheetName Then
                  SheetExists = True
                  Exit For
              End If   
          Next
          
          If SheetExists = False Then
              'If the sheet dont exists, create
              .Sheets.Add(After:=.Sheets(.Sheets.Count)).Name = SheetName
          End If
      End With 
  End Sub
  </code></pre>