CXllCom::OleWorksheetFindFormula

Search for an instance of a formula in a worksheet

static HRESULT OleWorksheetFindFormula(
   LPDISPATCH dispWorksheet,
   LPCSTR pszSearch,
   LPDISPATCH dispLastRange,
   CString& strFirstAddress,
   LPDISPATCH* lpdisp
);

Parameters

dispWorksheet

Worksheet object.

pszSearch

The string to be searched for.

dispLastRange

The range returned by the last call to OleWorksheetFindFormula(). NULL the first time the function is called.

strFirstAddress

If this string is empty, it will be filled with the first address where the search starts. On subsequent calls, it will be used as a stop marker for the search.

lpdisp

If the function is successful, the range containing the search string will be placed here. It is the responsibility of the caller to Release() it.

Requirements

Header: xlpcom.h

See Also

CXllCom Class | CXllCom Methods