web query format

  • Thread starter Thread starter Bill C
  • Start date Start date
B

Bill C

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.
 
Here are a couple of ideas you can modify to suit your needs.
'at the start
Sheets("Data").Rows("2:300").Delete
=====
'at the end
For Each Name In Sheets("Data").Names
Name.Delete
Next Name
========
 
Back
Top