April 2006
Beginner
1114 pages
98h 16m
English
querytable.RowNumbers[= setting]
Set this property to True to display row numbers in the first column of the specified query table. The numbers do not display until the query table is refreshed. They will be reset each time the query table is refreshed. The following code adds row numbers to the first query table on the active worksheet:
With ActiveSheet.QueryTables(1)
.RowNumbers = True
.Refresh
End WithRead now
Unlock full access