Method 'Delete' of object 'Hyperlinks' Failed

[magoobee]

I copy data from Yahoo Finance into a spreadsheet. I then run the following code

Sub ZapHyperlinks()
   Cells.Hyperlinks.Delete
End Sub

I then get the error
Run-Time error '2147417848 (80010108)'
Method 'Delete' of object 'Hyperlinks' Failed

I have tried deleting all the fields with Yahoo Hypertext in it. But when I run the macro again, it finds other areas to blow up on.

Any clue what is going on?

 

[venkat1926]

tgry this code

suppose hyperlinks are in A1 to A10

range("A1:A10").hyperlinks.delete

 

[Bill H]

How about...

ActiveSheet.Hyperlinks.Delete

That should remove all hyperlinks on the entire sheet. A bit drastic, but it does the trick for me.

 

[magoobee]

This seemed to work

range("A1:A10").hyperlinks.delete

but after running that,

ActiveSheet.Hyperlinks.Delete
Cells.Hyperlinks.Delete

still did not work

Thanks