With this code, the query result will be written starting from cell "A1".With ActiveSheet.QueryTables.Add(Connection:=connstring, Destination:=Range("A1"), Sql:=sqlstring) .Refresh End With
I want the query result to be written starting from the active cell I just clicked, How can I do that?
Thanks