title: Excel VBA - Like function does not evaluate to true
body: <p>I am stuck at VBA Like function &quot;not functioning&quot; properly.</p>
  <p>Here is my simple Excel table:</p>
  <p><a href="https://i.stack.imgur.com/SB8af.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SB8af.png" alt="Just 3 columns of data" /></a></p>
  <p>Earlier in my code I'm getting the row count and assigning it to the byteRowCount variable, Account Name column index to the byteAcctColNum variable. Then, I iterate over the Account Name column and search for the row where the Account Name is &quot;Customer 1&quot; and the Product contains the string &quot;Information&quot; with the following code:</p>
  <pre><code>For i = 2 To byteRowCount
      
  If sh.Cells(i, byteAcctColNum) = &quot;Customer 1&quot; And (CStr(sh.Cells(i, byteProdColNum).Value) Like &quot;*Information*&quot;) Then
          boolCust1InfCases = True
  End If
  </code></pre>
  <p>The challenge is, the (CStr(sh.Cells(i, byteProdColNum).Value) never evaluates to True (I Step Into and check in the Immediate Window.)</p>
  <p>Any ideas on why this is not working?</p>
  <p>Thanks!</p>