Hi
i use the following bit of code to delete Hyperlinks when I cut and paste data from the internet to excel.
[vba]Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub[/vba]
It works very well most of the time, BUT when I get a large amount of data, last example was just over 2000 lines with a single hyprelink in each row, I get the following error.
Originally Posted by Microsoft Visual Basic
When i debug it highlights ActiveSheet.Hyperlinks.Delete
Any help you can provide is much appreciated.
Thanx
Grant