|
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 |
How to clear links to external workbook
http://www.j-walk.com/ss/excel/usertips/tip054.htm or type in Finding links in your forum search bar -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=522317 |
How to clear links to external workbook
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 |
| All times are GMT +1. The time now is 12:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com