title: use WorksheetFunction with ctrl shift enter in VBA excel
body: <p>I want to write a VBA code to find matching cell based on given value without considering Text and Number.</p>
  
  <p>We can do it in Excel like this: <code>=match("*207*", C:C &amp; "",0)</code> with pressing <kbd>Ctrl</kbd>+<kbd>Shift</kbd>+<kbd>Enter</kbd>.</p>
  
  <p>But in VBA the code <code>pos = WorksheetFunction.Match(lookup_value, lookup_range &amp; "", 0)</code> doesn't work.<br>
  Is there any solution?</p>