.Find method w/ Dates
Posted by yu-kuan on August 23, 2000 8:50 PM
I have a cell (say, A1) that the user enters a date into, like "2000/7/31". I would then like to use the .Find method to find this date in a range of cells, but for some reason the .Find method cannot seem to find it.
code as follows:
Set cell = .Find(InputDate) 'InputDate is the cell w/ the date the user has entered.
if Not cell is Nothing then
row = cell.row
However, the .Find method is not working, as it is always returning pointing cell to Nothing, and I'm sure InputDate exists in the first column of the active sheet.
Any help will be greatly appreciated.