Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
How do I copy email address behind the hyperlink text in Excel, using VBA. I want to put the email address in the cell beside the hyperlink. Using office 2007.
Name: aegappen Date: March 13, 2009 at 09:10:08 Pacific
Reply:
I found this code that helped me a lot. Sub HyperLinkAddressToLeft() Dim h As Hyperlink For Each h In Selection.Hyperlinks h.Range.Offset(0, -1).Value = h.Address Next h End Sub
Summary: ok, that was a lot of what i was looking for, but a little too indepth. i just need a copy and paste type of thing. yours did copy, but it copied EVERYTHING. what im trying to do is copy all of the co...
Summary: BigShow, In the tutorial did you notice all of the F_ fields? Many of those fields are needed in order for the forms.cgi script to work! For instance, no where on your current quote page is there an e...
Summary: Yes, Ill let my secret out! Lol. On the page of the .swf file, get the source (View > Source) or right click and do View Source. HTML Code should open in Notepad or somewhat. Now find something like t...
0 
