Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft