I a issue with the Excel FIND and the .FIND Method. I have some VBA that uses the .FIND method which looks for a date along a row of dates. See below. The code would not find the date. So i tried finding it using the Excel FIND and it would not find it also.
So in the options I change the lookin: from Values to formula and then it found it. I then changed the code to do the same and it now finds it. But what is puzzling is that the dates have be typed in as values and are not formulas, am I missing something.
So in the options I change the lookin: from Values to formula and then it found it. I then changed the code to do the same and it now finds it. But what is puzzling is that the dates have be typed in as values and are not formulas, am I missing something.
Excel Workbook | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | |||
1 | Lookup Date | 16/08/2010 | 26/07/2010 | 02/08/2010 | 09/08/2010 | 16/08/2010 | 23/08/2010 | ||||||||||||||||||||||||||||
2 | Venue Code | Network | Count | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | ||
3 | 601 | ESS | 1 | 708 | 708 | 736 | 708 | 736 | 708 | 708 | |||||||||||||||||||||||||
4 | 602 | ESS | 1 | 708 | 708 | 736 | 708 | 736 | 708 | 708 | |||||||||||||||||||||||||
sheet1 |