Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink address
sI would like to take the hyperlink address from one cell that has a
hyperlink associated with it and paste the hyperlink address as a string into another cell. In otherwords if cell A1 has a hyperlink assigned to it of http://googgle.com, then paste that as a string in cell B2. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink address
Try
With Range("A1") If .Hyperlinks.Count 0 Then Range("b1").Value = .Text End If End With -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Scott" wrote in message ... sI would like to take the hyperlink address from one cell that has a hyperlink associated with it and paste the hyperlink address as a string into another cell. In otherwords if cell A1 has a hyperlink assigned to it of http://googgle.com, then paste that as a string in cell B2. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink: Why am I getting ../../../ in the address bar? | Excel Discussion (Misc queries) | |||
Hyperlink into Address | Excel Programming | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Display hyperlink as web address | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |