removing hyperlinks

[Kyli]

I copied and pasted a spreadsheet from the web and there
are about 75 hyperlinks on it. Is there a quicker way to
remove all hyperlinks at a time, instead of right clicking
each link and removing it? Thanks!

 

[Ron de Bruin]

Hi Kyli

You can use

ActiveSheet.Hyperlinks.Delete