Skip to content

Latest commit

 

History

History
48 lines (28 loc) · 1.06 KB

Excel.Range.ID.md

File metadata and controls

48 lines (28 loc) · 1.06 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.ID property (Excel)
vbaxl10.chm144231
vbaxl10.chm144231
Excel.Range.ID
0ff7f261-8829-2858-5097-a638c01e5f3c
05/11/2019
medium

Range.ID property (Excel)

Returns or sets a String value that represents the identifying label for the specified cell when the page is saved as a webpage.

Syntax

expression.ID

expression A variable that represents a Range object.

Remarks

Use an ID label as a hyperlink reference in other HTML documents or on the same webpage.

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 webpage, and the following line of HTML is added to the webpage. When the user then views the page in a web browser and chooses the hyperlink, the browser displays the cell.

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

[!includeSupport and feedback]