Identifying cells with external links using VBA

[Mark Jarvis]

I want to be able to identify cells in a spreadsheet that
contain formulas with links to other workbooks.

Does anybody know how to use VBA to do this?


Cheers,

Mark

 

[Dave Peterson]

Maybe you could just look through the cells with formulas that have .xls in them
(or the square bracket character ([) as long as it's not used as text!)

But I'd really use Bill Manville's findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm