• Find


    In XL 2000, I have suddenly run into the inability to use Find in a worksheet. I am searching for the date 01/09/2001, it is in a cell by virtue of the formula =’Week 11′!$B$1. XL reports, “Microsoft Excel cannot find the data you’re searching for. …” I have tried all the options (Values, Formulas, By rows, By columns) but no sucess. I have witten a macro with the statement: Cells.Find(What:=MyValue, After:=ActiveCell, LookIn:=xlValues, _
    LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
    It doesn’t work either.
    Any ideas?

    Viewing 0 reply threads
    • #1775615

      I tried it and it works. It has to be by value and you do have to search for the date in the right format. If it’s formated as 1/9/01 and you seach for 1/9/2001 it doesn’t work.

      • #1775620

        Right on the money! The disciplined act of getting both the search criteria (by value) and the format (m/d/yyyy) correct fixed both the worksheet search and the macro.
        Thanks a bunch.

    Viewing 0 reply threads
    Reply To: Find

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: