VBA cannot recognize remote dependencies (i.e. it only recognizes
dependencies on the active sheet). The best solution I can think of is to
show dependencies for all cells on the worksheet because that will show
remote dependencies as well. Manually this would be a tediuos task but this
code will do it for you.

Sub CellsDeps()

Dim rng As Range

For Each rng In ThisWorkbook.ActiveSheet.UsedRange
rng.ShowDependents
Next rng

End Sub

Of course you can "Unshow" all the dependencies with Tools - Formula
Auditing - Remove All Arrows.

Hope this helps.



"rajesh" wrote:

Hi

I would like to highlight cells that are not having any dependents (i.e.,
any other cell in the same worksheet or another worksheet does not depend on
the cell to be validated).

any possible solution through vba / macro is of great help.

thanks in advance