VBA: Add Hyperlink

[guido124]

Hi Guys,

How do I add a Hyperlink?

I want to construct it from two cells.
Cell 1 contains a path, cell 2 contains the actual file.

 

[guido124]

Easy:

Sub Addlink()
    
    
    For i = 35 To 54

        With Worksheets(1)
            .Hyperlinks.Add .Range("O" & i), Range("I" & i) & "\" & Range("K" & i)
        End With
    
    Next i
    

    
End Sub

 

[guido124]

Can somebody delete this topic?