Hello All:

First of all any help would be great.  I have a macro which shows the
Trace Dependents Audit Arrows.  I would like to add to it to check for
any cell that contains data call a particular macro.

This other macro interacts with another application as well as excel
and puts a comment in the given selection.

The original macro looks like this:

Sub ShowDependents()
'
For Each cell In Selection
  cell.ShowDependents

Next cell
End Sub

This traces any dependents.  I would like for it to also for those
cells that are not blank or empty to call the other macro xyz which in
turn inserts the comment and references the external application.

Example:

Row    A    B
1    300    =RemoveHiddenApostrophe!A8
2
3    300
4
5    4A
6
7    5A

Cell "A1" would have a formula linking to somewhere else.

If you have any ideas they would be greatly appreciated.

Thanks,

Jacob