FINDSHAPEBYLABEL
Finds a shape using its unique shape identifier. Shape can exist anywhere in the document. To get a shape's identifier use LABEL.
Syntax
=FINDSHAPEBYLABEL(identifier)
=#identifier
Arguments
| Argument | Type | Description |
|---|---|---|
| identifier | String | The identifier of the shape to find |
Examples
| Text | Identifier | Name |
|---|---|---|
| "Shape 1" | "xyz123" | "Ringo Starr" |
=FINDSHAPEBYLABEL('xyz123') → "Shape 1"
Returns a reference to Shape 1
=#'xyz123' → "Shape 1"
Alternate syntax to return a reference to Shape 1
=FINDSHAPEBYLABEL('xyz123')."Name" → "Ringo Starr"
Returns the "Name" property from Shape 1
=FINDSHAPEBYLABEL('abc789') → #ERROR!
Error if no shape with that identifier exists
Updated over 1 year ago