Results 1 to 3 of 3

Thread: Find

  1. #1
    ellisbill
    Guest

    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, _
    MatchCase:=False).Activate
    It doesn't work either.
    Any ideas?

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find

    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.

  3. #3
    ellisbill
    Guest

    Re: Find

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •