External Link

[diego]

I have a workbook with a lot of external links. What I
want to do is use VBA to clear content any cell that has
external link. I am guessing it will involve for loop
checking the property of the cell, I just don't know which
property I should check.

Does anyone know how to do this ?

Thanks

 

[Dave Peterson]

You might be able to loop through the formula cells and search for .xls or
square brackets ([). Then change the .value to .value.

But MS has a macro that you might like to look at:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q126093
XL: Macros to Delete Formula Links