title: Why wont VBA Next go to next Worksheet
body: <p>So I've been looking on here for a while and I'm trying to make code that goes through every sheet in the workbook unless the sheets are named Summary, Archive, or Template. When running the code it seems to skip the code when I start on a sheet with any of these three names but never goes to the next sheet. (It may be important to mention that my code involves going to another workbook to gather data).</p>
  
  <p>Here's what I have:</p>
  
  <pre><code>For Each rs In ActiveWorkbook.Worksheets
  
  If rs.Name &lt;&gt; "Summary" And rs.Name &lt;&gt; "Archive" And rs.Name &lt;&gt; "Template" Then
  
  
      'my Code to do
  
  
  End If
  Next rs
  </code></pre>
  
  <p>Any help would be <strong>greatly</strong> appreciated.
  Thanks</p>