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!
With ActiveSheet.Cells(1, 1).Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
.resize(UBound(myarray), UBound(myarray, 2)).value = myarray
End With
‘Source: https://www.ozgrid.com/forum/forum/other-software-applications/excel-and-web-browsers-help/131683-extracting-data-from-a-grid-on-webpage
Bookmarks