Forum Discussion

KB7GP

Copper Contributor

Nov 22, 2022

HYPERLINK

Is there a process to select a column of web addresses and convert or activate them as hyperlinks? Dave

excel

HansVogelaar

MVP

Nov 22, 2022

KB7GP

To convert text values to hyperlinks, select the cells with web addresses and run the following macro:

Sub Convert2Hyperlinks()
    Dim rng As Range
    Application.ScreenUpdating = False
    For Each rng In Selection
        ActiveSheet.Hyperlinks.Add Anchor:=rng, Address:=rng.Value
    Next rng
    Application.ScreenUpdating = True
End Sub

KB7GP

Copper Contributor

Nov 23, 2022

HansVogelaar

thank you for the macro. I will try it.
Dave