Range.ID (Excel)

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

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

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