Identifying cells with external links using VBA
 

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

Identifying cells with external links using VBA
 

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

Mark Jarvis wrote:

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