Databar.MaxPoint (Excel)

Returns a ConditionValue object that specifies how the longest bar is evaluated for a data bar conditional format.

You can specify the type and value of the evaluation by using the Type and Value properties of the ConditionValue object.

Dim cveMaxPoint As ConditionValue
Set cveMaxPoint = ActiveCell.FormatConditions(1).MaxPoint