View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I restore the LookIn, LookAt, SearchOrder in FIND

If you asking if you can query the state of those settings in your macro, to
the best of my knowledge, the answer is no.

So I don't know how you would reset them unless you have a standard
setting - then you could execute a dummy find with those settings at the end
of your macro.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
When I've used a macro which uses the FIND method, the settings of
LookIn, LookAt and SearchOrder are changed for the CTRL-F function!

So how can I restore the settings for LookIn, LookAt and SearchOrder
when I exit a macro?

Thanks!