ID Property

Microsoft Excel Visual Basic

Returns the type for the specified object. Read-only Long.

expression.ID

expression    Required. An expression that returns one of the above objects.

ShowID property as it applies to the Range object.

Returns or sets the identifying label for the specified cell when the page is saved as a Web page. Read/write String.

expression.ID

expression    Required. An expression that returns a Range object.

Remarks

You can use an ID label as a hyperlink reference in other HTML documents or on the same Web page.

Example

This example sets the ID of cell A1 on the active worksheet to "target".

ActiveSheet.Range("A1").ID = "target"
		

Later, the document is saved as a Web page, and the following line of HTML is added to the Web page.

<A HREF="#target">Quarterly earnings</A>
		

When the user then views the page in a Web browser and clicks the hyperlink, the browser displays the cell.