COMException Unhandled

Question

I am running this code:
string[] lStats= new string[] { "Overboard" };
dynamic totalStats = oXL.ActiveWorkbook.Sheets[1].Cells.Find(lStats, XLFindLookIn.xlValues, XlLookAt.xlWhole).Offset[0,4].Value;

And it throws a COMException was unhandled. Type Mismatch(Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))

Vulpes · Answer

I think that the problem here is that you're not passing anything for the second parameter (After) and the run time can't therefore bind the arguments you are passing to the correct parameters. To deal with this I'd try using 'named' parameters for the second and third arguments: dynamic totalStats = ws1.Cells.Find(lStats LookIn : XlFindLookIn.xlValues LookAt : XlLookAt.xlWhole).Offset[04].Value;