Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Extract text from hyperlink
10 views
Skip to first unread message
JP
Feb 7, 2007, 11:28:00 PM2/7/07
to
I have an Excel sheet that contains a column of cells that are hyperlinks.
Is there a way to extract the text of the hyperlink? For example, the cell
contains a company, (Microsoft) that is hyperlinked to
http://www.microsoft.com. I would like to extract the
http://www.microsoft.com and put in a cell.
Is there a way to extract the text of the hyperlink? For example, the cell
contains a company, (Microsoft) that is hyperlinked to
http://www.microsoft.com. I would like to extract the
http://www.microsoft.com and put in a cell.
Thanks.
Tom Ogilvy
Feb 7, 2007, 11:51:36 PM2/7/07
to
Dim hlnk as Hyperlink
for each cell in Range("C1:C50")
for each hlnk in cell.hyperlinks
cell.offset(0,1).Value = hlnk.Address
Next
Next
for each cell in Range("C1:C50")
for each hlnk in cell.hyperlinks
cell.offset(0,1).Value = hlnk.Address
Next
Next
--
Regards,
Tom Ogilvy
"JP" <J...@discussions.microsoft.com> wrote in message
news:1B069FC8-0F35-4F3F...@microsoft.com...
JP
Feb 8, 2007, 8:45:01 AM2/8/07
to
thanks!
0 new messages