<< Click to Display Table of Contents >> Results.ArrayCounts Property |
Returns an array with the overall number of differences found as text. Read only Array.
expression.ArrayCounts
expression. A variable representing a Results object.
This property returns an array. Each difference 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 |
Total |
Total differences of worksheet pair. |
2 |
Columns |
Overall differences of missing columns (source¦target). |
3 |
DupRecs |
Overall differences of duplicate records. |
4 |
DupKeys |
Overall differences of duplicate keys. |
5 |
Rows |
Overall differences of missing rows (source¦target). |
6 |
Content |
Overall differences of entered values/formulas. |
7 |
Values |
Overall differences of calculated values. |
8 |
Formats |
Overall differences of format differences. |
9 |
Comments |
Overall differences of cell comments. |
10 |
Names |
Overall differences of cell Excel names. |