Hey guys

The below code finds the address of the first occurance of
the specified value (variable). Lets say the variable is
equal to "Mouse". Lets say mouse was located in cell C4,
C100, and C322. When the code is run, test would equal
C322 because cell C322 is the location of the first
instance of that value it sees. This works fine accept
when the variable is equal to a date.

In this case, variable CL.Value = 06/22/2004. When the
below code is run, the result is empty. What do I need to
do to fix this?

test = Range("C65536").End(xlUp).Find(CL.Value).Address