list of linking cells
 

Hi,
Is there a way via VBA to list all the cells that is to retrieve info from
other workbooks (i.e. cells with formulas such as
='D:\[sample.xls]Sheet1'!A11)
TIA
J_J

list of linking cells
 

get FindLink addin from
http://www.bmsltd.ie/MVP/Default.htm

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


J_J wrote :

Hi,
Is there a way via VBA to list all the cells that is to retrieve info
from other workbooks (i.e. cells with formulas such as
='D:\[sample.xls]Sheet1'!A11)
TIA
J_J

list of linking cells
 

Thanks keepITcool,
That was cool...:)
J_J

"keepITcool" wrote in message
ft.com...
get FindLink addin from
http://www.bmsltd.ie/MVP/Default.htm

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


J_J wrote :

Hi,
Is there a way via VBA to list all the cells that is to retrieve info
from other workbooks (i.e. cells with formulas such as
='D:\[sample.xls]Sheet1'!A11)
TIA
J_J