I am trying to call Application.WorksheetFunction.Exact. I did do a search trying to find the solution to (so far) no avail.
Here is what I have attempted:
Set deltaCell = ActiveWorkbook.Sheets("qry_invalid_deltas").Range("z4")
Set outCell = deltaCell.Offset(0, -1)
Set inCell = outCell.Offset(0, -1)
debug.print(CDbl(deltaCell.Value) <> CDbl(outCell.Value) - CDbl(inCell.Value))
Debug.Print (Application.WorksheetFunction.exact(deltaCell, outCell - inCell))
Does anyone have any suggestions? Thank you for your assistance.
>Solution :
Since Exact isn’t supported by WorksheetFunction, use the equal operator to compare strings exactly as the Exact function:
CStr(deltaCell) = CStr(outCell - inCell)