This documentation is archived and is not being maintained.

RowNumbers Property [Excel 2003 VBA Language Reference]

Office 2003

True if row numbers are added as the first column of the specified query table. Read/write Boolean.


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.


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

With Worksheets(1).QueryTables("ExternalData1")
    .RowNumbers = True
    .FieldNames = True
End With

Applies to | QueryTable Object