Highlight cells with no dependents

  • I am trying to find cells that do not have any dependents, either define them in a pop up box, or, hightlight them a different color. I did a search and found the following code, but it does not find most of the cells that dont have dependents and much of the time says that there are no cells that dont have a dependant when there is.



    There an error in the above code or there a better way to do this?

  • Re: Cells with no dependents?


    see if this helps