I'm searching a column for a date using a string value eg. "1/08/2011", however FindString() cannot find it. My code example is:
Dim dateCell As Cell
Dim dateArea As New CellArea()
dateArea.StartColumn = 0
dateArea.StartRow = 0
dateArea.EndColumn = 0
dateArea.EndRow = 365
dateCell = sheet.Cells.FindString("1/08/2011", Nothing, dateArea, False)
When looking at the spreadsheet the cell displays "1/08/2011". I've also tried searching for "01/08/2011" to no avail. Searching for 40756 (the excel serial date) as a number or string also does not work.
I can use the exact code and look for a string like "Hello" and it works fine.
Am I searching for dates using the correct method? If not how should I be doing it?