Results 1 to 3 of 3
2001-01-11, 21:23 #1ellisbillGuest
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.
2001-01-11, 21:34 #2
- Join Date
- Dec 2000
- Thanked 0 Times in 0 Posts
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.
2001-01-11, 21:45 #3ellisbillGuest
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.