You can have a piece of code that will find all dependents / precedents of
all the cells within the selection, albeit it will only flag the ones with
deps / precs on the activesheet - Would that help?

--
Regards
Ken.......................


<snip