MaximumNumberOfRanges Property

Returns the maximum number of Range objects definable for an Exception object.

Syntax

Ranges.MaximumNumberOfRanges

Applies To

Discussion

Use this property to determine the maximum number of ranges that you can define for an exception. Currently an Exception object can have a maximum of 5 ranges. Therefore this property always returns 5.

Type

Long

Access

Read

Example

This example shows the maximum number of ranges definable for an exception.

Sub Main

   Dim objPPRep As Object

   Dim objPPRange As Object

   Set objPPRep = GetObject(,"CognosPowerPlay.Report")

   Set objPPRange = objPPRep.Exceptions.item(1).Ranges

   MsgBox "Maximum Number of Ranges = " & _

         objPPRange.MaximumNumberOfRanges

   Set objPPRange = Nothing

   Set objPPRep = Nothing

End Sub