title: Use find method when there are merged cells, vba excel
body: <p>I have a question about using the <code>.find</code> method in Excel VBA when there is a merged cell in the searching range. Here is the code:</p>
  
  <pre><code>Dim SearchCell As Range
  Set SearchCell = ActiveSheet.Range("A:A").Find(What:="Open RMA*", LookIn:=xlValues)
  </code></pre>
  
  <p>SearchCell is empty after running the code, I guess because A26:K26 is merged as one cell while the value is "Open RMA"; I don't want to unmerge it though.</p>