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 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/visio/", 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 (click Hyperlinks on the Insert menu).

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

Cell name:

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

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

Section index:	visSectionHyperlink
Row index:	visRowHyperlink + i where i = 0, 1, 2…
Cell index:	visHLinkSubAddress