Hyperlinks.CreateHyperlink(Area, String)

Description

Creates a new hyperlink in the specified area of cells. All cell values in the area will be converted to hyperlinks.

Parameters

area

An Area object representing the cells that will be converted to hyperlinks.

href

The hyperlink's destination.

Returns

A new Hyperlink object with the specified destination URL.

Remarks

Creating a hyperlink to another cell or range within the workbook is not supported. However, you may use a hyperlink formula to achieve the same functionality. For example, to link to cell C3 you would use the formula =HYPERLINK("#Sheet1!C3", "Link to C3"). Setting Cell.Formula with this formula will create the internal hyperlink.

Examples