title: Using a InStr function within a Select Case
body: <p>This does not seem to be working. Is there a way to do what I am trying to do here? I cant a case to be selected if the value is in a given sting:</p>
  
  <pre><code>Select Case gTTD.Cells(r, 4)
  
       Case InStr(gTTD.Cells(r, 4), "MASTER LOG")
           resp = "MM LOG"
        Case InStr(gTTD.Cells(r, 4), "MASTER MET")
           resp = "MM MET"
       Case "PIR"
           gTTD.Cells(r, 7) = "Martin TrÃ©panier"
           resp = "Martin TrÃ©panier"
  
   End Select
  </code></pre>
  
  <p>I understand why this cant work but is there a way of making it work? thank you</p>
  
  <p>Thank you</p>