Pasting array starting in a specific range

[Chrispelletier]

Hello,

I am having trouble modifying part of a macro I found. The macro use internet explorer to download all HTML tables found on a specific website. It stores the tables information it in an array and then paste that array starting at the last row found in column A. I would like instead to start pasting the array in A2. I tried playing around with the code such as removing the end(xlUP) but without success; I also try Application.Transpose but no success there as well. FYI the array will vary in size depending on the website. Here is the code I am having trouble with, thank you for your time!

Please Login or Register  to view this content.

[nigelog]

try

Please Login or Register  to view this content.

[Chrispelletier]

Yeah working... easier than I thought, should have thought about that myself Thanks for your quick response!