title: If Sheet Name Doesn't Exist, How to Skip to the Next Loop?
body: <p>i is an arraylist of names. j is using that list as tab names. The problem Im running into is that  if that range of cells has an empty cell in it -- or if the name in the array list doesn't exist how would I &quot;skip that name&quot; (or empty cell) and go to the next loop? I think it would be under j, but I'm not sure where to begin other than an if statement? not sure how to write an if statement for that either?</p>
  <pre><code>Set Tail = New ArrayList
  
  Dim NewestEntry As Integer
  Dim Apple As String
          
  For i = 0 To 20 Step 3 'Tail #/Number of Tails
  
      Apple = Worksheets(&quot;StepBrief&quot;).Cells(i + 6, 3).Value
      Tail.Add Apple
                          
  Next i
  
  For j = 0 To 20 'Number of Tail # Cells
          
              NewestEntry = Worksheets(Tail(j)).Range(&quot;A:A&quot;).Cells.SpecialCells(xlCellTypeConstants).Count
  </code></pre>