Finding a date value in Excel

[acdetc]

I'm trying to open a worksheet, and determine what row a specific Date (e.g. 08/01/2004) is in. I found this code:

Set FoundCell = Range("A1:A100").Find (what:="7/18/1998")

which creates an object 'FoundCell'. I assume it is a Range object, but I can't seem to access any of it's properties?

 

[SkipVought]

acdetc,

If there are REAL DATES in column A then "7/28/1998" will NEVER work. Why? Because REAL DATES are NUMBERS and NOT STRINGS.

Set FoundCell = Range("A1:A100").Find (what:=DateSerial(1998,7,28))

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}