Export (0) Print
Expand All
Expand Minimize

SubAddress Cell (Hyperlinks Section)

Office 2007

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
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