I'm trying to paste the target of a hyperlink from a website into Word or excel. It's proving to be very difficult. When I copy the hyperlink from the website, it's the hyperlink itself that is pasted. The target information is attached, and I can follow (& open) the target in both Word & Excel, but I would like to just paste the target info itself instead of opening the target. I would greatly apreciate any help. Thanx

If you right click on a hyperlink (such as those on the left), you will be presented with a menu. Select "Copy shortcut" and the URL of the page you would be taken to had you clicked the link will be copied to the clipboard. Then paste this in Word/Excel. -Ryan Adams Free Computer Tips and more:http://RyanTAdams.com Paid Tech Support: Black Diamond

Thanks for your help. I'm aware of that, and it will work, but... My problem lies in that I'm copying a list of almost 200 objects, but the copy shortcut option will only copy one at a time, even if many are selected. I can copy and paste all of the objects, which are all hyperlinks, then I could even edit the hyperlink, copy & paste. But I'm afraid of carpel tunnel...

Oh, I think I see what you are getting at. Could you post a link to the page with these hyperlinks so I can see how they are formatted. -Ryan Adams Free Computer Tips and more:http://RyanTAdams.com Paid Tech Support: Black Diamond

It's kind of sensitive, so I'll PM you

This should help you see the light at the end of your carpel tunnel: Paste your links as HTML into a spreadsheet, select them and run this code. It should put the URL for each link in the next column. It worked with the links in the left hand column of this website. Sub HyperLinkAddress() On Error Resume Next For Each hLink In Selection Range(hLink.Address).Offset(0, 1) = hLink.Hyperlinks(1).Address Next End Sub

Brilliant! That did the trick. Thanks very much, everyone!