View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default Capture Find Settings

Range.Find takes a number of argument. What, LookIn, LookAt, SearchDirection,
.... These settings are saved each time you run a find meaning that in order
to be safe you are best off to supply values for each of the arguments.
However when you do this the values are saved and when the end user brings up
their Find or Find and Replace dialogue they are presented with whetever
settings that the code left them at. My question... Is there a way to capture
these settings prior to running the Find code so that you can restore them to
their original state when the find code is complete.
--
HTH...

Jim Thomlinson