RefreshStyle Property

Applies To

QueryTable object.

Description

Returns or sets the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query. Read/write Long.

Can be one of the following xlCellInsertionMode constants.

Constant

Description

xlOverwriteCells

No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.

xlInsertDeleteCells

Partial rows are inserted or deleted to match the exact number of rows required for the new recordset.

xlInsertEntireRows

Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.


Example

This example adds a query table to Sheet1. The RefreshStyle property adds rows to the worksheet as needed, to hold the data results.

Dim qt As QueryTable
Set qt = Sheets("Sheet1").QueryTables _
    .Add(Connection:="Finder;C:\Myfile.dqy", _
        Destination:=Range("Sheet1!A1"))
With qt
    .RefreshStyle = xlInsertEntireRows
    .Refresh
End With