As I've found, this and all previously net posted solution to tracking Precedents or Dependents fail or, in the worst case of all of a formula's cell addresses being text value concatenations, completely fail.

The culprits are the volatile functions INDIRECT and OFFSET. You will get any root target cell as a precedent but, if that target root cell is targeted by an INDIRECT text construct using & or CONCATENATE you will find no precedents even using the Formula Ribbon "Find" P or D.

Your thoughts on this gap would be wonderful.