Remove Hyperlinks

[enquirer]

Hi All
I've copied 2 x columns x 760 rows of data from a web site and pasted to a new workbook. The data in column 1 are all sequential numbers for fault codes and each has a hyperlink. How can I remove all the hyperlinks, as I only require the number. I've tried pasting as text, but then I lose the columns.
Thanks Simon

 

[VoG]

Hi. Try running this

Sub NoHl()
ActiveSheet.Hyperlinks.Delete
End Sub

 

[enquirer]

Thanks Peter.
Worked instantly
Regards Simon