QueryTable.ResultRange Property

Syntax

expression.ResultRange

expression A variable that represents a QueryTable object.

Remarks

The range doesn't include the field name row or the row number column.

Example

This example sums the data in the first column of query table one. The sum of the first column is displayed below the data range.

Set c1 = Sheets("sheet1").QueryTables(1).ResultRange.Columns(1) c1.Name = "Column1" c1.End(xlDown).Offset(2, 0).Formula = "=sum(Column1)"

See also:

• QueryTable Object
• QueryTable Object Members