About Us

Luc[_3_]

In excel 2003 an 2007, in cell A1 I have the name microscoft. This cell is a
link: "http://office.microsoft.com/en-us/FX102855291033.aspx"
I want to have the text of this
(http://office.microsoft.com/en-us/FX...291033.aspx)in cell B1. I can do
this with copy and paste, but I want ot do this with a macro? Can you help me?
--
Luc

Luke M

Sub GetAddress()
Range("B1") = Range("A1").Hyperlinks(1).Address
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Luc" wrote:

In excel 2003 an 2007, in cell A1 I have the name microscoft. This cell is a
link: "http://office.microsoft.com/en-us/FX102855291033.aspx"
I want to have the text of this
(http://office.microsoft.com/en-us/FX...291033.aspx)in cell B1. I can do
this with copy and paste, but I want ot do this with a macro? Can you help me?
--
Luc

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i remove an excel link that break link won't remove	brosull	Excel Worksheet Functions	1	June 29th 09 06:34 PM
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document.	tln	Links and Linking in Excel	0	April 22nd 07 04:28 PM
if i sort cell that has link to another page how to keep link	steve Bahrain	Excel Discussion (Misc queries)	1	August 16th 06 01:20 PM
if i sort cell that has link to another page how to keep link	steve Bahrain	Excel Discussion (Misc queries)	0	August 16th 06 07:37 AM
Link to external link	Chris Wong	Excel Worksheet Functions	0	August 3rd 06 07:00 AM

Menu

About Us