Expand Minimize

Range.ClearHyperlinks Method (Excel)

Removes all hyperlinks from the specified range.

Version Added: Excel 2010

expression .ClearHyperlinks

expression A variable that returns a Range object.

Return Value

Nothing

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.

Community Additions

ADD
Show:
© 2014 Microsoft