Identifying the cells contained in a formula 2

[popper]

Hi

Using VBA, I want to be able to examine a formula in an Excel cell and generate a list of cells referred to in it. Anyone know how to do this?

With thanks in advance

 

[Fenrirshowl]

You will need to use the precedents property. Not knowing exactly what you want, hopefully something in the following will help.

Sub listdeps()
For Each i In ActiveCell.Precedents
    MsgBox i.Address
Next i
End Sub

 

[Loomah]

or even just
msgbox activecell.precedents.address

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​