Редагувати

Поділитися через

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>

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.