Macro to launch a dynamic url in a cell

[mhodges2021]

I'm very new to Macros and all things excel and have been trying to find the correct code or help for days.

I have a few urls that are all dynamically built with the hyperlink formula based on populated data on other sheets. One of my sheets contains all the of website formulas for the workbook. I am trying to build a macro that would launch the url in a certain cell on a certain sheet. I have been playing with different code that I have found from different people's answers to similar questions and have come up with this code that doesn't work:

Sub Launch_Hyperlink()
Worksheets("Websites").Range("B19").Hyperlinks(1).Follow
End Sub

The URL I'm trying to launch is in cell B19 on the sheet I have labelled "Websites"

 

[EXCEL MAX]

Hello Mhogess2021,
try in this way...

Sub Launch_Hyperlink()
  
    With Worksheets("Websites")
'delete old link
        .[B19].Delete
'insert new web address
        .[B19] = "https://www.mrexcel.com/"
'create link from web address
        .Hyperlinks.Add [B19], [B19].Value, , , [B19].Value
'open browser
        .[B19].Hyperlinks(1).Follow
    End With
  
End Sub