Find

Topic

New Reply

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?

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote