This documentation is archived and is not being maintained.

<SubAddress> element

<SubAddress> element

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Specifies a location within the target document to link to.

For example, for a given Hyperlink element:

  • If the Address element is the Microsoft Excel file "Samples.xls", the value of this element can be a worksheet or range within a worksheet, such as "Worksheet Functions" or "Sheet1!A1:D10".
  • If the Address element is "", the value of this element can be a named anchor within the document, such as "solutions".


    [Unit = "unitval"]
    [F = "formula"]
    [Err = "error"]> 



Optional string. Represents a unit of measure. The default is STR. For details about STR, see Units of measure.


Optional string. Represents the element's formula. This attribute can contain the string "someFormula" if the formula exists locally, "No Formula" if the formula is locally deleted or blocked, or "Inh" if the formula is inherited.

If the attribute is not present, the element's formula is a simple constant, for example, <element> 5 </element>.


Optional string. Indicates that the formula evaluates to an error. The value of Err is the current value (an error message string); the value of the element is the last valid value.

Element information

Parent elements: Hyperlink

Child elements:



See also