Ok, so I'm still not able to understand how to extract the links from trace precedents Goto menu.
Please find attached the picture below.
How do I extract
'[Book2]Testing Worksheet'!$B$1
[Book2]Sheet3!$B$1
from this window i.e. the 1st precedents from the active cell.
Could anyone please help me achieve this via VBA. It is the first part of my approach and I can't find this info anywhere else on the web.
Thanks,
