|
<< Click to Display Table of Contents >> Results.ArrayDetails Property |
  
|
|
<< Click to Display Table of Contents >> Results.ArrayDetails Property |
|
Returns an array with the detail information of the specified differences found as text. Read only Array.
expression.ArrayDetails(Type)
expression. A variable representing a Results object.
Name |
Type |
Description |
Type |
Constant selects group of results to return. If not set, all result types are returned. |
This property returns an array. Each difference is is represented by a single element of the array with 11
columns. The first element of the array contains the column headings.
Column # |
Name |
Description |
0 |
Name of source worksheet. |
|
1 |
Adr1 |
Range address of source worksheet |
2 |
Adr2 |
Range address of target worksheet |
3 |
Val1 |
Cell value/formula of source worksheet |
4 |
Val2 |
Cell value/formula of target worksheet |
5 |
Key |
Primary key (only if database) |
6 |
Fld |
Field name (only if database) |
7 |
TypeName |
Type of difference. The following difference types are displayed: - DuplicateRec (duplicate records) - DuplicateKey (duplicate keys) - MissingRow (different rows) - DifferentContent (different entered values/formulas) - DifferentValue (different calculated formulas/results) - DifferentFormat (different formats) - DifferentComment (different cell comments) - DifferentName (different Excel names) |
8 |
TypeSort |
Type number of difference. |
9 |
ColSort |
Column number of difference. |
10 |
RowSort |
Row number of difference. |