Clear Find Settings

  • Hi All,

    In microsoft word you can clear find criteria like below.

    Does anyone know how to do this with excel?

    Thanks in advance.

  • Re: Clear Find Settings

    Hi Robert,

    Thanks for the reply.

    Unfortunately thats not what I was looking for. That is help to clear formatting for cells.

    I am trying to change the criteria of the find. Ie when you goto edit find there will be the previous finds options set. I want to change these with code but without doing a find.


  • Re: Clear Find Settings

    would something like this work?

  • Re: Clear Find Settings

    Hi Ross,

    Thanks for the reply.

    That helps, however I could have sworn I remember reading a post here on ozgrid with a similar way to how you would do it in word as I posted at the start.

    Maybe I am loosin it. Thanks again.

  • Re: Clear Find Settings

    Thanks for your help Robert.

    While Aarons find function truly is a master peice, I think the key to my question is to manipulate the find settings without actually doing a find.

    However, I am starting to think Im leading people on a wild goose chase. So I think ill use an alternative way.

    Thanks again for all your help.

  • Re: Clear Find Settings

    No problem.

    While it's probably not the most efficient way, try the following (change the variable type if string is not suitable):

    Dim strFindVariable As String
    strFindVariable = "Find_Me"
    Application.SendKeys ("^f")
    Application.SendKeys (strFindVariable)

    This simply leaves the Find and Replace dialog box open with strFindVariable in the Find_what: drop-down list.


    : D

Participate now!

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