Method 'Delete' of object 'Hyperlinks' Failed

magoobee

New Member
Joined
Nov 22, 2004
Messages
39
I copy data from Yahoo Finance into a spreadsheet. I then run the following code

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?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
tgry this code

suppose hyperlinks are in A1 to A10

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

Bill H

New Member
Joined
Mar 23, 2002
Messages
21
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

New Member
Joined
Nov 22, 2004
Messages
39
This seemed to work

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

but after running that,

ActiveSheet.Hyperlinks.Delete
Cells.Hyperlinks.Delete

still did not work

Thanks
 

Forum statistics

Threads
1,141,754
Messages
5,708,317
Members
421,564
Latest member
Ian_20210927

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top