If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
List links (via function)
Hello all,
Is there a way to show the (full) name of links in a range of cells. I know you can do this manually with "findlink", but am looking for a way that on my "master print" also the name of all linked workbooks is shown. Thanks in advance, Johannes |
#2
|
|||
|
|||
Johannes van der Pol wrote:
Is there a way to show the (full) name of links in a range of cells. I know you can do this manually with "findlink", but am looking for a way that on my "master print" also the name of all linked workbooks is shown. You could write a VBA function to do it or you can use a defined name. Insert / Name / Define / MyLinks RefersTo:=TRANSPOSE(LINKS(,1)) Then in a worksheet, select cells in a column equal in number to the number of Excel links in the workbook and enter =MyLinks as an array formula (Ctrl+Shift+Enter) If you also have DDE links you can do a similar trick using LINKS(,2) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Cool, a lot easier than I thought.
Thanks, Johannes "Bill Manville" schreef in bericht ... Johannes van der Pol wrote: Is there a way to show the (full) name of links in a range of cells. I know you can do this manually with "findlink", but am looking for a way that on my "master print" also the name of all linked workbooks is shown. You could write a VBA function to do it or you can use a defined name. Insert / Name / Define / MyLinks RefersTo:=TRANSPOSE(LINKS(,1)) Then in a worksheet, select cells in a column equal in number to the number of Excel links in the workbook and enter =MyLinks as an array formula (Ctrl+Shift+Enter) If you also have DDE links you can do a similar trick using LINKS(,2) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
test | test | General Discussion | 0 | November 22nd, 2004 11:09 PM |
Creating a function to randomize a list of alphanumeric entries in an array | Gabby | Worksheet Functions | 5 | November 24th, 2003 08:28 AM |