<div>
If it does not meet the criteria I do not want it to execute the code after the Next WS line...if the condition is not met I need it to go to then next worksheet
</div>


If it does not meet the criteria I do not want it to execute the code after the Next WS line...if the condition is not met I need it to go to then next worksheet

That's why it says: if <b>not</b> ... Like

<div>
So the code I've put does this<br />
<br />
For each worksheet in workbook<br />
If not condition then<br />
Do stuff<br />
End if<br />
Next worksheet<br />
<br />
Do more stuff at the end
</div>


So the code I've put does this

For each worksheet in workbook
If not condition then
Do stuff
End if
Next worksheet

Do more stuff at the end

<div>
<div class="content wysiwyg-content">
In the below I want to go to the next worksheet if the condition is not met..The only way I could figure this out was by doing GOTO..What is a suggestion<br />
<br />
For each ws in this workbook<br />
&nbsp; If ws.Range (&quot;A2&quot;) Like &quot;2013&quot; Then<br />
&nbsp; &nbsp; GOTO Next<br />
&nbsp; else<br />
&nbsp; code line<br />
&nbsp; code line<br />
&nbsp; code line<br />
&nbsp;code line<br />
NEXT:<br />
Next ws<br />
&nbsp;code line<br />
&nbsp;code line<br />
&nbsp;code line<br />
&nbsp;code line<br />
<br />
End Sub
</div>
</div>


In the below I want to go to the next worksheet if the condition is not met..The only way I could figure this out was by doing GOTO..What is a suggestion

For each ws in this workbook
  If ws.Range ("A2") Like "2013" Then
    GOTO Next
  else
  code line
  code line
  code line
 code line
NEXT:
Next ws
 code line
 code line
 code line
 code line

End Sub

Go to the next record

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.