List off destination - source cel

[Dedeke]

Hello,

I wonder if it is possible to create a list off destination and source cells from a worksheet.
I do know the build in fuction for sourc- and destination cells, but as far as i know it shows only for the selected (active) cel.
I want to modify an existing sheet.
So for example: In a Table i don't need 2 columns. How could i find out if those columns are maybe needed for some other formulas??

Using exel 2016 Dutch version

Hope this make sense.....

 

[Rijnsent]

For that you would have to go over all the cells (manually or by a macro) and use the that same function you found... There are add-ins that help with this, so depending on how useful it is for you you could buy one of those or build a one-off macro.