title: excel vba finding with like or regex
body: <p>I'm writing a VBA program.
  I have a problem with finding this string <code>[BLOCKED]</code> in one column</p>
  
  <pre><code>For j = 0 To 4
      For i = 2 To lastrow
          If Cells(i, 12).Value = groupnames(j) And Cells(i, 8).Value Like "*" &amp; "[BLOCKED]" &amp; "*" Then
              groupsum(j) = groupsum(j) + 1
          End If
      Next i
  Next j
  </code></pre>
  
  <p>The problem is I have 96 cells for this string but the program found 500 how can I do this to going work?<br>
  Thanks for help</p>