how do i see which cells / columns have dependents?

[bigdan]

A lot of the cells in one of my worksheets are irrelevant. I'd like to know which ones I can skip filling in in the future. At the moment if it's worth it I click on a cell in each column and click on Dependents. That does the job but of course it's not ideal.
Is there a way to see all the dependents?
I'm confused as to why Microsoft didn't just enable this ability to highlight a range and click Dependents and all of them show up.

 

[Eric W]

Interesting coincidence. Just this morning I wrote a quick macro to do just that.

Open a copy of your workbook. Press Alt-F11 to open the VBA editor. Press Alt-IM to Insert a Module. Paste the following code into the window that opens:

Sub FindDependents()
Dim c As Range

    ActiveSheet.ClearArrows
    For Each c In ActiveSheet.UsedRange
        c.ShowDependents
    Next c

End Sub

Press Alt-Q to close the editor. Go to the sheet you want to check. Press Alt-F8 to open the macro selector. Choose FindDependents and click Run.

 

[bigdan]

sorry just seeing this. thanks so much!