I have a bit of code that inserts a query table from a record set. I'd much rather it overwrite the existing data in the cells than push it out to the side. Does anyone know of a trick to do so?
Code:
Set qtbData = wks.QueryTables.Add(rst, wks.Range("A2"))