Hi Everyone I'm trying to replicate the Excel functionality to find formulas that don't match with a reference formula.
In Excel you can write this: Selection.RowDifferences(ReferenceCell) Excel will return all cells who's formulas don't match with the ReferenceCell. The problematic part I can see of doing this manually is that Excel is able to recognise relative references. So if cell D4 has a formula of "=C3 + 2" and cell D5 has a formula of "=C4 + 2" then it knows these are matching. Is there anything that will help me accomplish this without writing a full formula parser and comparator? Thanks Stuart --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
