Pair Object |
  
|
Pair Object |
|
Container for a pair of worksheets to compare.
Specify a Range
Normally the entire data range of the sheet is used, but you set the range using the RangeAddr property.
Compare as Database
You can compare the sheets as databases when
· your data is organized in a tabular layout, with descriptive headers above each column.
· rows can be uniquely identified by a primary key.
You must set the primary key using the DBKeys property.
You can specify the starting row of the database with the DBRow property.
When you want the records sorted or the results grouped, use DBOptions .
.