Hello

I've an excep application in VSTO.
In some point i want to be able to find if a perticular date is in a range.

my code is:

rng = rng.Find( date,
Type.Missing,
Excel.XlFindLookIn.xlFormulas,
Type.Missing,
Type.Missing,
Excel.XlSearchDirection.xlNext,
Type.Missing,
Type.Missing,
Type.Missing);

where rng is a well defined Excel.Range(i've checked it) and date is my
DateTime object to find.

This method find always returns null... i guess that's hapenning 'cause
diferences
in date formats from c# and Excel.

Can you help me here... how can i search a range for a date?!

i'm loosing my mind over here

best regards

Jorge