Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
Determine Find/Replace settings and then restore them? | Excel Programming | |||
cannot find c:\documents and settings | Excel Discussion (Misc queries) | |||
Use VBA to capture IP address | Excel Programming | |||
Up Capture | Excel Programming |