CONTAINERSHEETREF Function
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Version Information
Syntax
Remarks
Example
Returns a sheet reference to the specified container that contains the shape.
CONTAINERSHEETREF(index[, category])
Parameters
|
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
|
index |
Required |
Integer |
The 1-based index of the container. See Remarks for more information. |
|
category |
Optional |
String |
The category of the container. See Remarks for more information. |
Return Value
ShapeSheet reference
The index of a container is calculated based on the z-order of containers from front to back.
Categories are user-defined strings that you can use to categorize shapes. You can define categories in the User.msvShapeCategories cell in the ShapeSheet for a shape. You can define multiple categories for a shape by separating the categories with semi-colons.
If the shape is not a member of a container, or if there is no container that matches both the specified index number and the category, CONTAINERSHEETREF returns #REF!.