How to insert a hyperlink in sheet? 1

[JensKKK]

I am frequently using the =hyperlink() function in workbooks.

Now I want to insert a hyperlink with VBA in my workbook.

This is the code I tried to use, but the compiler stops in line 4. Any ideas how to insert a hyperlink into a workbook with VBA

Many thanks

part1 = "

http://www.google.com"

part2 = "google"
part3 = "=hyperlink(" & part1 & "," & part2 & ")"
msg = MsgBox("msg: " & part3)
Sheets("detailed results").Cells(5 + i + j, 2) = part3

 

[Andrzejek]

if you record a macro, this is what you will have:

    Range("A1").Select
    ActiveSheet.Hyperlinks.Add _
        Anchor:=Selection, Address:= _
        [blue]"[URL unfurl="true"]http://www.google.com"[/URL][/blue], TextToDisplay:=[blue]"My google"[/blue]

Have fun.

---- Andy

 

[JensKKK]

Thanks Andy

Code works fine.