vba find/replace change tab

  • I have some code which brings up the find/replace box but it brings up the replace rather than the find. Is there a way to bring up the find tab?

    Hereis the code

    Also, I have an anomoly regarding the find. Sometimes it scrolls down to the row using the above code but other times the found result is in the information box but it doesn't scroll to that row. Any ideas?

  • Re: vba find/replace change tab

    My pleasure, thanks for the feedback. :cheers:

    Quote from mmmr;797891

    That's fantastic. Thanks. Is there a list of these id numbers somewhere do you know?

    I don't know, I did a search to find that code.

  • Re: vba find/replace change tab


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!