title: VBA Evaluate function with string arguments
body: <p>I have this function working ( It returns the row where the text DK001 sits in the ID range)</p>
  
  <pre><code>Found = Application.Evaluate("=IF(ID=""DK001"",ROW(ID),""x"")")
  </code></pre>
  
  <p>I would like to feed the searchcriteria (e.g. DK001) as a string, like</p>
  
  <pre><code>Found = Application.Evaluate("=IF(ID=SearchString,ROW(ID),""x"")")
  </code></pre>
  
  <p>I fail in creating a string that is accepted as a search criteria. I need your help on this! What am I doing wrong?</p>
  
  <hr>
  
  <p>This Evaluate function is haunting me ....</p>
  
  <p>What if I now wanted to send a value (not a string) to the function?</p>
  
  <pre><code>Found = Application.Evaluate("=IF(ID=1,ROW(ID),""x"")")
  </code></pre>
  
  <p>The above works!</p>
  
  <p>But if I want this to be a variable like</p>
  
  <pre><code>Found = Application.Evaluate("=IF(ID=MyValue,ROW(ID),""x"")")
  </code></pre>
  
  <p>What then?</p>