title: Checking Existing Sheet names in list
body: <p>I want to check whether an existing tab or worksheet is in a list of tab names, say in Column A. Column A is found in a tab called Import RPT.</p>
  <p>If the name exists I want the code to end and create a MsgBox saying that a spreadsheet already exists in row i of column A, if not continue.</p>
  <p>I've combined pieces from Stack Overflow:</p>
  <pre><code>Dim sht As Worksheet, r As Range
  
  With Sheets(&quot;Import RPT&quot;)
      For Each sht In Worksheets
          Set r = sht.Cells.Range(&quot;C2:C&quot; &amp; Count)
          If Application.WorksheetFunction.CountIf(Range(&quot;rngSheetInclusions&quot;), sht.Name) &gt; 0 Then
              strResult = strResult &amp; &quot;Duplicate Name: &quot; &amp; r &amp; vbNewLine &amp; &quot;Rows: &quot; &amp; _
              Left(dict.Item(r), Len(dict.Item(r)) - 1) &amp; vbNewLine &amp; vbNewLine
              MsgBox strResul
  
      Next
  </code></pre>