如何将源代码粘贴到列(C列)而不粘贴到单元格(C1)中?
Sub Tester()
Range("c1").Value = Getsource("https://www.yahoo.com/")
End Sub
Function Getsource(sURL As String) As String
Dim oXHTTP As Object
Set oXHTTP = CreateObject("MSXML2.XMLHTTP")
oXHTTP.Open "GET",sURL,False
oXHTTP.send
Getsource = oXHTTP.responsetext
Set oXHTTP = Nothing
End Function