Share via

FindRowMember Property

  • Article

Finds a row member, given a reference to the member. Returns a PivotRowMember object.

expression.FindRowMember(Path, Format)

*expression   * Required. An expression that returns a PivotRowMember object.

Path   Required String. A variable or string that contains a reference to the member to find.

PivotMemberFindFormatEnum

PivotMemberFindFormatEnum can be one of these PivotMemberFindFormatEnum constants.
plFindFormatMember Member reference is a named path. For example, "USA\Oregon\Portland".
plFindFormatPathHex Member reference is a path of hexadecimal indexes.
plFindFormatPathInt Member reference is a path of indexes. For example, "1\0\5\1".
plFindFormatPathName Member reference is a unique name or can be a name if unambiguous. For example, "[USA].[Oregon].[Portland]".

Remarks

If the requested member is not found, a PivotRowMember object with the IsValid property set to False is returned. This allows you to refer to a member that might later be added to the schema.

Applies to | PivotRowMember Object