Removes all hyperlinks from the specified range.
Syntax
expression.ClearHyperlinks
expression A variable that returns a Range object.
Return value
Nothing
Remarks
Calling the ClearHyperlinks method on the specified range is equivalent to using the Clear Hyperlinks command from the Clear drop-down list in the Editing section of the Home tab. Only hyperlinks will be removed; all other cell content, such as text and formatting, will be unaffected.
Examples
The following example clears hyperlinks from all the cells on Sheet1 in the active workbook.
Worksheets("Sheet1").Cells.ClearHyperlinks