EvPRP 
The EvPRP (Property list) function returns the properties of a specified dimension.
Syntax
EvPRP(AppName,Dimension,Destination Range)
AppName — The name of the application. This is required if the corresponding dimension does not exist in the active application.
Dimension — The name of the dimension for which you want to return the properties.
Destination Range — The references for the destination cells.
InApp — True returns properties stored in the OLAP cube. False returns all properties.
End of the code.
Example
The following example returns CALC, GROUP, HLEVEL, ORGANIZATION, and STYLE, since they are InApp properties of the Category dimension.
EvPRP(Finance,Category,Sheet1!A1:A5,true)
End of the example.