I am looking for a way to list in a sheet the cells and formulae that are involved in circular references. Any references involved in a circular chain will be contained on the same sheet.
I can see this property
ActiveSheet.CircularReference
That returns the range containing the FIRST circular reference of the range. I am trying to loop though a range and return every reference in the range in a list.
I can see the complete list of references here
Formulas > Formula Auditing > Error Checking > Circular References
and I would like this list of cells in a sheet.
There is some code here: http://support.microsoft.com/kb/125848
but it seems to overstate the list and include cells that have some interdependence but no circularity.
Anyone managed to do this?
I can see this property
ActiveSheet.CircularReference
That returns the range containing the FIRST circular reference of the range. I am trying to loop though a range and return every reference in the range in a list.
I can see the complete list of references here
Formulas > Formula Auditing > Error Checking > Circular References
and I would like this list of cells in a sheet.
There is some code here: http://support.microsoft.com/kb/125848
but it seems to overstate the list and include cells that have some interdependence but no circularity.
Anyone managed to do this?
