Hi all

I am using the following code to import multiple web queries onto a single worksheet. 

    For i = 0 To 7
        With ActiveSheet.QueryTables.Add(Connection:="URL;" & arrURL(i), Destination:=Range("a65536").End(xlUp))
            .WebFormatting = xlWebFormattingNone
            .Refresh BackgroundQuery:=False
        End With
    Next i
The trouble is as each Web query runs, the previously downloaded ones disappear. Do you know how I prevent this from happening?

Thanks in advance