EssZoomIn

Description

Zooms in on the selected members.

Syntax

EssZoomIn([workbookName]sheetName, range, selection, level, across)

Where [workbookName]sheetName is the text name of the workbook and worksheet to which the retrieve occurs.

range is a reference to the area of data to be retrieved.

selection is a reference to the affected member or members.

level is a number which indicates the granularity of the zoom. The level parameters and associated action are shown in Table 39.

Table 39. Level Parameters and Actions

Level	Action
1	Zoom In to next level (children).
2	Zoom In to all levels (descendants).
3	Zoom In to the lowest level (bottom).
4	Zoom In using siblings.
5	Zoom In to same level.
6	Zoom In to same generation.
7	Zoom In via calculation script.

across is a logical value that specifies whether the resulting zoomed in data should appear in the spreadsheet going across or down. A TRUE value indicates that the data should be displayed across while a FALSE value indicates that the data should be displayed downward. across is only meaningful for top-level members of a dimension, also known as dimension or title members (for example, Products in Sample Basic).

Example

=EssZoomIn("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20, SAMPLE.XLS!B2,2,FALSE)

Notes:

The active spreadsheet is used when the sheetName parameter is missing.
The contents of sheetName is used when the range parameter is missing.
The active cell of sheetName is used when the selection parameter is missing.
A value of 1 is assumed when the level parameter is missing.
A value of FALSE is assumed when the across parameter is missing.