Hi,

I'm hoping someone on this forum can help me. I'm trying to figure
out how I can use VBE in Microsoft Excel (2003) to convert hyperlinked
GIF images in a spreadsheet. I already know how to convert
hyperlinked words into the original text, but I can't figure out how
to do the same for pictures.


The GIF images paste into a spreadsheet fine, but I get an error
message when I use the following macro (found on
http://www.developersdex.com/vb/mess...77&r=6138512):


Option Explicit


Sub RemoveLinks()
Dim prngCell As Range


For Each prngCell In Selection
prngCell = prngCell.Hyperlinks(1).Address
prngCell.Hyperlinks.Delete
prngCell = Replace(prngCell, "mailto:", "")


Next prngCell
End Sub


The error message reads "Subscript out of range". Any help on this
would be greatly appreciated. I don't necessarily need to use VBE, so
I'm open to any other suggestions.


CB






*** Sent via Developersdex http://www.developersdex.com ***