Excel .Find, result of function VB 2010
===

I'm trying to use .Find in VB 2010 in order to find a result of a function.

This is my code:

    firstFind = xlWorkSheet.Range("E10", "CM10").Find(searchDate, ,     Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False)

I have tried both xlValues and xlFormulas.

The excel function is pretty simple and looks like this:

    =G9+7

The reslut is a date, 19-Jul, and that's what I want to be able to search for.

BR
Sebastian