Aussiebear
07-07-2023, 05:34 AM
In the attached workbook, I have an example of manually creating a working hyperlink by the following formula in cell C1
=hyperlink(B1,A1)
However if I try to recreate this by using a Sub, it fails with the following code Error Msg: Requires a separator and highlights the second line
Sub InsertHyperlinkInCell()
ActiveWorkbook.Worksheets("Sheet1").Range(C2).Formula = "=hyperlink(B2,A2)"
End Sub
I can't see where it would require one.
=hyperlink(B1,A1)
However if I try to recreate this by using a Sub, it fails with the following code Error Msg: Requires a separator and highlights the second line
Sub InsertHyperlinkInCell()
ActiveWorkbook.Worksheets("Sheet1").Range(C2).Formula = "=hyperlink(B2,A2)"
End Sub
I can't see where it would require one.