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 = "part2 = "google"
part3 = "=hyperlink(" & part1 & "," & part2 & ")"
msg = MsgBox("msg: " & part3)
Sheets("detailed results").Cells(5 + i + j, 2) = part3
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 = "part2 = "google"
part3 = "=hyperlink(" & part1 & "," & part2 & ")"
msg = MsgBox("msg: " & part3)
Sheets("detailed results").Cells(5 + i + j, 2) = part3