Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

RefreshStyle Property [Excel 2003 VBA Language Reference]

Office 2003

XlCellInsertionMode can be one of these XlCellInsertionMode constants.
xlInsertDeleteCells. Partial rows are inserted or deleted to match the exact number of rows required for the new recordset.
xlOverwriteCells. No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.
xlInsertEntireRows. Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.


expression Required. An expression that returns one of the objects in the Applies To list.


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", _
With qt
    .RefreshStyle = xlInsertEntireRows
End With

Applies to | QueryTable Object

© 2015 Microsoft