Identifying cells with external links using VBA

Mark Jarvis · Nov 20, 2003

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 · Nov 21, 2003

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

Identifying cells with external links using VBA

Mark Jarvis

Dave Peterson