VBA: function to get/set the search settings (for backup and restore)
Range.Find modifies the settings in the Find dialog of the UI.
The default setting of LookAt in the UI is xlPart, but in VBA we usualy use xlWhole:
MyRange.Find(What, LookIn:=xlValues, LookAt:=xlWhole)
We need a function the get (all) the search settings, so we can backup the settings before we execute our macro. And when we are finished we need a function to restore the settings.