I am trying to devise a macro that would identify cells that are dependents and am encountering great difficulty.
My problem is when I run my macro I get only the first dependent to be highlighted and nothing else in the range, even if it is a dependent, shows up as being dependent.
I have huge spreadsheets with a lot of information that can be cut out, so I think this macro would help identify some of my waste in these spreadsheets.
So if you have any suggestions or code to try please let me know.
Thanks