I am using the web query:
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://webpage.com?" & courseCode _
, Destination:=Range("A9"))
And this picks up a 4 row by 5 column table.
The problem is that when it pastes this into the range A9 it inserts 5
colums there. I don't want it to insert columns but rather just to
paste into the cells that are already there. Does anyone know the code
for this?
Thank you.