Creates a new hyperlink in the cell pointing to the specified href. This hyperlink is automatically added to the worksheet. The cell value will be converted to hyperlinks.
hrefThe hyperlink's destination.
ReturnsA Hyperlink object.
RemarksCreating 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.