Hi,

I want to use macro to open a website which is stored as hyperlink in my sheet e.g. in A1. I have been using a macro, which had a direct link in its code, but now
want the macro to take the link that is in a given cell e.g. from A4.

What do I need to put after the "GET", before False at the end?

 
    With CreateObject("msxml2.xmlhttp")
        .Open "GET", "Webpage address from a cell in the sheet e.g. Sheet 1, A1", False
        .Send
        oDom.body.innerHtml = .responseText
    End With
Thank you