Thread: How to clear links to external workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wilbur[_9_] Wilbur[_9_] is offline
external usenet poster
  
Posts: 1
Default How to clear links to external workbook

I have code that I use FORMULAR1C1 = "Index(...., Match(...))" into an
unused cell, then copy and pastespecial for paste value only and then
clear the contecnts of the cell I put the Index/Macth in.

Does that clear the link and if not how can that be done in VBA? The
file needs to become smaller somehow...


--
Wilbur
------------------------------------------------------------------------
Wilbur's Profile: http://www.excelforum.com/member.php...o&userid=31826
View this thread: http://www.excelforum.com/showthread...hreadid=522317

Reply With QuoteReply With Quote