It is expecting a Range object not an address:JoeWinograd wrote:Hi FG,
That will be great stuff if I can get it to work, but so far haven't been able to. Here's what I tried:
It says that it is unable to get the IsFormula property of the WorksheetFunction class:
What is wrong with the code above? Thanks, Joe
Xl := ComObjActive("Excel.Application")
MsgBox % Xl.WorksheetFunction.IsFormula(Xl.Range("A1"))
CellNumber := oExcel.Range("A1")and of course put it after you create the
It is also important to remember that Excel will return -1 as true.