title: if range of cells contains string then goto
body: <p>I know this is a topic that is talks about a lot, but I just cant find the answer.</p>
  
  <p>I have a range. if in that range there is a word then I need it to go to the next code. if not, than skip the next code and move on.</p>
  
  <p>I'm unable to define the range.  </p>
  
  <p>this is my code:</p>
  
  <pre><code>For a = 4 To 20
      If (Range("H" &amp; a).Value = "*nice*") Then
          GoTo Clean 
      Else
          GoTo pre
      End If
  Next 
  </code></pre>
  
  <p>In the range I do have the word "nice" but it still skips clean and goes straight to pre.</p>
  
  <p>whats wrong? how do i define my range and how can the code understand that in my range the word nice" IS IN there.</p>