VBA Level Constants

Table 22 lists the constants defined in ESSXLVBA.TXT. You can use them in functions, such as EssVGetMemberInfo and EssVZoomIn, that require you to specify an outline level as a parameter.

Table 22. VBA Level Constants

ConstantValueDescription

EssChildLevel

1

Next level

EssDescendentLevel

2

All levels

EssBottomLevel

3

Bottom level

EssSiblingLevel

4

Sibling level

EssSameLevel

5

Same level

EssSameGenerationLevel

6

Same generation

EssCalculationLevel

7

Calc level

EssParentLevel

8

Previous or parent level

EssDimensionLevel

9

Dimension member belongs to