Name

CalculatedMember Object

Synopsis

Path: Application  --  Range  --  PivotTable  --  CalculatedMembers - CalculatedMember
               

Object

Methods

Properties

CalculatedMember

  • Delete( )

  • Formula( ) As String

  • IsValid( ) As Boolean

  • Name( ) As String

  • SolveOrder( ) As Long

  • SourceName( ) As String

  • Type( ) As XlCalculatedMemberType

CalculatedMembers

  • Add(Name As String

  • Formula As String

  • [SolveOrder] As Variant

  • [Type] As Variant) As CalculatedMember

  • Count( ) As Long

  • Item(Index As Variant) As CalculatedMember

The CalculatedMember object programmatically manipulates the calculated fields and calculated items for PivotTables that are connected to external OLAP (Online Analytical Processing) data sources. We will not discuss these data sources further in this book.

Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.