Creates a new hyperlink in the area pointing to the specified href. This hyperlink is automatically added to the worksheet. All cell values in the area will be converted to hyperlinks.
hrefThe hyperlink's destination.
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.