The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

QueryTable Object

Office 2007
Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database.


The QueryTable object is a member of the QueryTables collection.


Use QueryTables(

index), where index is the index number of the query table, to return a single QueryTable object. The following example sets query table one so that formulas to the right of it are automatically updated whenever it’s refreshed.
Visual Basic for Applications
Sheets("sheet1").QueryTables(1).FillAdjacentFormulas = True

Community Additions

© 2015 Microsoft