Querytables.Add problem with destination Range

[paloji]

Hi everyone!!

First of all, sorry for my English, I´ll try to explain myself as best as I can ^^u

I am downloading a website on a sheet using querytables, but I don´t wont to dowload everything, the website has a lot of information I don´t need, just need some of the firsts rows, so I want it to stop around cell B9 (don´t need anything after it). I call this functions a lot of times in a loop, so it takes a lot of time doing innecesary work...

I´ve tried with:

With Hoja2.QueryTables.Add(Connection:= _
    "URL;" + Hoja1.Cells(i, 10).Value, Destination:=Range("A1:B9"))
    .Refresh BackgroundQuery:=False
    End With

But it still loading the full page. Is it possible to stop it on B9?? or will always load everything??

Thank you very much in advance.