macros using find/replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I record a macro to bring up the dialog box for find/replace and leave
open. Each time I record and stop the macro after the box is open, it does
not stay open. The replaced data will be different each week and requires
the user to update.
 
Why do you want the dialog box to be open at all - why not just prompt
for the details (with a custom userform I would suggest) and then get
the macro to do the find and replacing using these parameters?
 
Back
Top