Results.ArrayCounts Property

<< Click to Display Table of Contents >>

Navigation:  Developer Edition > Visual Basic for Applications (VBA) > Object Model Reference > Results Object > Properties >

Results.ArrayCounts Property

Previous pageReturn to chapter overviewNext page

Returns an array with the overall number of differences found as text. Read only Array.

 

Syntax

expression.ArrayCounts

expression. A variable representing a Results object.

 

 

Description of Array

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

Source

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.