Edit

Address Cell (Hyperlinks Section)

  • Article

Specifies a URL address, file name, or UNC path to which to jump.

You can specify Address as a relative path based on the base path defined for the document in the Hyperlink base box on the Summary tab of the Properties dialog box (click the File tab, click Info, click Properties, and then click Advanced Properties). If the document has no base path, the application navigates based on the document path. If the document has not been saved, the hyperlink is undefined.

Remarks

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

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

Value Description
Cell name:
Hyperlink. name .Address where Hyperlink. name is the name of the hyperlink row

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

Value Description
Section index:
visSectionHyperlink
Row index:
visRow1stHyperlink + i where i = 0, 1, 2...
Cell index:
visHLinkAddress