VBA Web query

Hello all,

I'm trying to use VBA to download data from the web.

The Macro goes like this :

Please Login or Register  to view this content.

This macro downloads infos about model 1858 in a table starting in Cell "A1".

Let's say that I have models 1858 to 1865 And I want information about model 1859 to be downloaded in cell A50
information about model 1860 to be downloaded in Cell A99

How do I change the macro ?
Thank you very Much

Originally Posted by daffodil11

I just made a For..Next loop from 1858 to 1865. The value of i is concatenated into the strings, and the destination is expressed as "$A$" & 1 + x, with a loop to increase x by 49 per cycle.

Please Login or Register  to view this content.

That completely solved the issue.

Thank you very much for your help.