SubAddress Cell (Hyperlinks Section)
Specifies a location within the target document to link to.
Remarks
For example, if the Address cell is "Drawing1.vsd", the SubAddress cell can specify a page name such as "Page-3". If the Address cell is the Microsoft Office Excel file "Samples.xls", 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 using the Hyperlinks dialog box (Insert menu).
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 |
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 |
Cell index: |
visHLinkSubAddress |