Syntax

expression.FetchedRowOverflow

expression A variable that represents a QueryTable object.

Example

This example refreshes query table one. If the number of rows returned by the query exceeds the number of rows available on the worksheet, an error message is displayed.

Visual Basic for Applications 
With Worksheets(1).QueryTables(1) .Refresh If .FetchedRowOverflow Then MsgBox "Query too large: please redefine." End If End With
Determine if recordset exceeds capacity of sheet? fetched fetched row overflow Fetched Row Overflow Property fetchedrow FetchedRowOverflow FetchedRowOverflow Property Find out if the results of a query are too large for worksheet? Last refresh overflows number of rows available on sheet?

See also: