How to show dependents for all cells in a selection at once?

  • Thread starter Thread starter Dmitriy Kopnichev
  • Start date Start date
D

Dmitriy Kopnichev

Hello
How to show dependents for all cells in a selection at once?
 
Sub ShowDependents()
'
For Each cell In Selection
cell.ShowDependents
Next cell
End Sub


Sub ShowPrecedents()
'
For Each cell In Selection
cell.ShowPrecedents
Next cell
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependant cell tracking 1
Excel Add ^ to a row of cells containing letters 3
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
How to select all comments in spreadsheet at once, to re-size all 1
Displaying zeros in cells 2
How do I change contents of a cell based on drop down list selecte 2
How to 'Trace dependents' for all cells in a selection at once? 6
how to apply absolute cell referencing to multiple cells at once? 2

Back
Top