Range.ClearHyperlinks Method (Excel)
Removes all hyperlinks from the specified range.
Version Information
Version Added: Excel 2010
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.