Expand Minimize
This topic has not yet been rated - Rate this topic

SubAddress Cell (Hyperlinks Section)

Published: July 16, 2012

Specifies a location within the target document to link to.

For example, if the Address cell is "Drawing1.vsdx", the SubAddress cell can specify a page name such as "Page-3". If the Address cell is the Microsoft Excel file "Samples.xlsx", the value of this cell can be a worksheet or range within a worksheet, such as "Worksheet Functions" or "Sheet1!A1:D10". If the Address cell is "http://www.microsoft.com/office/", the value of this cell can be a named anchor within the document, such as "solutions".

You can also set the value of this cell in the Hyperlinks dialog box (in the Links group on the Insert tab, click Hyperlink).

To get a reference to the SubAddress cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

Hyperlink.name.SubAddress where Hyperlink.name is the row name

To get a reference to the SubAddress cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionHyperlink

Row index:

visRow1stHyperlink + i where i = 0, 1, 2...

Cell index:

visHLinkSubAddress

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.