Yes, replacing the formula with the value it displays will remove a link
created by that formula. If the workbook contains other references to that
link, then you will need to remove them all to remove the link.

--
Regards,
Tom Ogilvy


"Wilbur" wrote in
message ...

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