Results.SumByType Property

<< Click to Display Table of Contents >>

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

Results.SumByType Property

Previous pageReturn to chapter overviewNext page

Returns the number of specified differences found. Read only Long value.

 

Syntax

expression.SumByType(Type,id)

expression. A variable representing a Results object.

 

Parameters

Name

Type

Description

Type

ResultType

Constant selects group of results to return.

id

sideID

Optional. Only needed for MissingCols and MissingRows.

Leave blank to return combined results.

 

Example

This example prints out some differences.

 

With oProj.Results

  'print out entered value/formula differences

  Debug.Print "Different values/formulas: " & .SumByType(ResultType_DifferentContent)

    

  'print out missing rows in source file

  Debug.Print "Missing Rows Source: " & .SumByType(ResultType_MissingRow, sideID_src)

 

  'print out missing rows in target file

  Debug.Print "Missing Rows Target: " & .SumByType(ResultType_MissingRow, sideID_tgt)

End With