Syntax

expression.RowNumbers

expression A variable that represents a QueryTable object.

Remarks

Setting this property to True doesn't immediately cause row numbers to appear. The row numbers appear the next time the query table is refreshed, and they're reconfigured every time the query table is refreshed.

Example

This example adds row numbers and field names to the query table.

Visual Basic for Applications 
With Worksheets(1).QueryTables("ExternalData1") .RowNumbers = True .FieldNames = True .Refresh End With
Add record numbers in front of each row in a query? Create row numbers for each record in a query table? Number rows in query? ROW row numbers Row Numbers Property RowNumbers RowNumbers Property

See also: