| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot find source of external workbook links | Excel Discussion (Misc queries) | |||
| Links to External Workbook | Excel Worksheet Functions | |||
| adjust links to external workbook automatically | Excel Discussion (Misc queries) | |||
| how can i delete external links from my workbook | Excel Discussion (Misc queries) | |||
| Links only update when external workbook is open | Excel Worksheet Functions | |||
![Wilbur[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
