Removing multiple HTML links across rows

[keywordmonkey]

Is there an easy way to remove all the hyperlinks in a sheet in one easy go without cutting and pasting the column into notepad?

I know how to remove individual links, but can't find anything about cleaning away all the links in one easy go, so I guess code is required.

Suggestions anyone?

 

[keywordmonkey]

A couple of days have passed, I've learnt some code and can answer my own question.

The below code runs across the active sheet on all cells.

Sub RemoveLiveLinks ()

' This macro removes any hyperlinks, so they become normal text and when clicked don't open a webpage
' It runs on every cell on the sheet

Application.ScreenUpdating = False

'The above stops the screen refreshing when code runs

Cells.Select

'Selects all cells on current sheet

Selection.Hyperlinks.Delete

'Deletes the underlying links

Application.ScreenUpdating = True

'This updates the screen after links removed

End Sub