Hi All

I have recorded this simple macro for getting Data from Web - I have replaced the URL as I have insufficient posts to even post a URL.

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;XXXX", Destination:= _
Range("$A$1"))

Question - how can I make the macro take the URL from a specific cell (say cell A1) on Sheet 1 and then make the destination Cell A1 in Sheet2?

Many thanks in advance.