title: IF sheet name contains specific text?
body: <p>I'm trying to do a bit of fail-safeing to check if the correct sheet is active before running the rest of the macro. The sheet is always the final sheet and it always contains a specific string but it also contains a number and that can vary (e.g. Field Map 1, Field Map 2, Field Map 3 etc), so the exact string is not always the same. I just need to know that the active sheet contains "Field Map" in the name regardless of the number.</p>
  
  <p>I need something like:</p>
  
  <pre><code>Sheets(Sheets.Count).Select
  
  If Not Activesheet.Name contains "Field Map" Then
  Msgbox ("Sheet not found")
  Exit Sub
  End If
  </code></pre>
  
  <p>I know the "Contains" bit doesn't exist but hopefully that explains what I'm trying to do?</p>