Range.ClearHyperlinks Method (Excel)

Removes all hyperlinks from the specified range.

Version Information

Version Added: Excel 2010


expression .ClearHyperlinks

expression A variable that returns a Range object.

Return Value



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.

See Also


Range Object

Range Object Members