Hi,
I have a web query which, when it places the data into the worksheet insists on inserting new columns if the results of the last query have not been deleted;

With QT
.Name = Cells(i, 61)
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertEntireRows
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "27"
.WebPreFormattedTextToColumns = False
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
End With
QT.Refresh BackgroundQuery:=False

Ideally I would like the new result set to overwrite existing data and/or if it needs to create new cells then they should be rows, not columns.

Thanks in advance for any solution!