title: Finding String in Cell VBA
body: <p>I'm looking to find a cell which contains DPD End. I want it to find the value farthest to the right because my row contains DPD End Jan, Feb, etc., so I'm looking for the most recent one, which will be located in the later columns.</p>
  <p>I'm currently seeing an error, even when I add a wildcard:</p>
  <pre><code>With ThisWorkbook.Worksheets(1).Rows(1)
      Set b = .Find(&quot;DPD End*&quot;, LookIn:=xlPrevious)
  MsgBox b.Column
  End With
  </code></pre>