title: Prevent Range.Find() from changing the "match entire cell content" user interface setting
body: <p>After running the first line of the following code, Excel changes the <strong>Match entire cell contents</strong> setting in the user interface. The result is that the next time the user presses <strong>Ctrl+F</strong> the search is done in the whole cell content. I don't like a VBA macro that changes a setting that affects the user experience, so I always execute the second line, which performs another search and sets the <strong>Match entire cell contents</strong> back to its default.</p>
  
  <pre><code>'execute the find and changes the entire cell content setting
  Set C = MyRange.Find(SomeText, LookAt:=xlWhole)
  
  'put the setting back to the default value (not the previous value)
  MyRange.SomeText ParName, LookAt:=xlPart
  </code></pre>
  
  <p>The problem is that it sets it back to the default, not to the value the user set it last.</p>
  
  <p>I would rather have something like:</p>
  
  <pre><code>'store the current entire cell content setting
  OldLookAt = Application.FindLookAt
  
  'execute the find
  Set C = MyRange.Find(SomeText, LookAt:=xlWhole)
  
  'restore the original setting
  Application.FindLookAt = OldLookAt
  </code></pre>
  
  <p>I made up the <code>Application.FindLookAt</code> because I wasn't able to find it. </p>
  
  <p>Is there a way to <code>Range.Find</code> something without affecting the user experience?</p>