Hyperlink text

[cloydsz]

Hello there,

I have TEXT in A1 and LINK in B1, is it possible to get the link from B1 and hyperlink it to A1?

Thanks!

 

[Logit]

Yes

Right click B1,select HYPERLINK / PLACE IN THIS DOCUMENT / SELECT THE SHEET.

Make certain you have entered A1 in 'Type The Cell Reference'

 

[cloydsz]

Hi, I have thousands of text and URLs in one sheet, is there any way to do that in one go?

 

[Logit]

If the URL is typed as www.somewhere.com it should auto display as a hyperlink.

Provide an example of what the text looks like in your cells. If possible, posting a sample project to DropBox.com or some other
cloud download location would be better. That way I can look at what you are dealing with.

Thanks

 

[cloydsz]

Hi https://www.mediafire.com/?3t3qhvhvcc7fohb

As you can see, there's headline in Column A and URL in Column B.

A2 Headlines should be hyperlink and get the link from Column B.

 

[Logit]

Paste this into a routine module and activate with a command button on the worksheet.

It will ask you to supply a range to be converted to hyperlinks. Ex: B2:B99

Option Explicit


Sub ConvertToHyperlinks()
'Updateby20140318
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", WorkRng.Address, Type:=8)
For Each Rng In WorkRng
    Application.ActiveSheet.Hyperlinks.Add Rng, Rng.Value
Next
End Sub

 

[cloydsz]

I think this is the answer that I'm looking for =HYPERLINK(link_location,friendly name)

 

[Logit]

Glad you have an answer. Cheers !