ShapeRange Members

  • Article

Include Protected Members
Include Inherited Members

Represents a shape range, which is a set of shapes on a document.

The ShapeRange type exposes the following members.

Properties

  Name Description
Public property Adjustments Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Applies to any ShapeRange object that represents an AutoShape, WordArt, or a connector. Read-only.
Public property AlternativeText Returns or sets the descriptive (alternative) text string for a ShapeRange object when the object is saved to a Web page. Read/write String.
Public property Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Public property AutoShapeType Returns or sets the shape type for the specified ShapeRange object, which must represent an AutoShape other than a line, freeform drawing, or connector. Read/write MsoAutoShapeType.
Public property BackgroundStyle Returns or sets the background style. Read/write.
Public property BlackWhiteMode Returns or sets a value that indicates how the specified shape appears when the presentation is viewed in black-and-white mode. Read/write MsoBlackWhiteMode.
Public property Callout Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to ShapeRange objects that represent line callouts. Read-only.
Public property CanvasItems Reserved for internal use.
Public property Chart Returns an object that represents the chart contained in the shape range. Read-only.
Public property Child Returns msoTrue if the specified shape is a child shape or if all shapes in a shape range are child shapes of the same parent. Read-only MsoTriState.
Public property ConnectionSiteCount Returns the number of connection sites on the specified shape. Read-only Integer.
Public property Connector True if the specified shape is a connector. Read-only MsoTriState.
Public property ConnectorFormat Returns a ConnectorFormat object that contains connector formatting properties. Applies to ShapeRange objects that represent connectors. Read-only.
Public property Count Returns the number of objects in the collection. Read-only Integer.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Public property Diagram Returns a Diagram object representing a diagram.
Public property DiagramNode Returns a DiagramNode object that represents a node in a diagram.
Public property Fill Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only.
Public property Glow Returns an object that contains glow formatting properties for the shape range. Read-only.
Public property GroupItems Returns a GroupShapes object that represents the individual shapes in the specified group. Applies to ShapeRange objects that represent grouped shapes. Read-only.
Public property HasChart Returns information on if a ShapeRange() contains a chart. Read-only.
Public property HasDiagram Returns whether a shape or shape range contains a diagram. Read-only MsoTriState.
Public property HasDiagramNode Returns a value indicating whether a diagram node exists in a given shape or shape range. Read-only MsoTriState.
Public property Height The height of the object. Read/write Single.
Public property HorizontalFlip True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState.
Public property ID Returns the type for the specified object. Read-only Integer.
Public property Left The distance from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart). Read/write Single.
Public property Line Returns a LineFormat object that contains line formatting properties for the specified shape. Read-only.
Public property LockAspectRatio True if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it. Read/write MsoTriState.
Public property Name Returns or sets the name of the object. Read/write String.
Public property Nodes Returns a ShapeNodes collection that represents the geometric description of the specified shape. Applies to ShapeRange objects that represent freeform drawings.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property ParentGroup Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes.
Public property PictureFormat Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to ShapeRange objects that represent pictures or OLE objects. Read-only.
Public property Reflection Returns a ReflectionFormat object for a specified shape range that contains reflection formatting properties for the shape range. Read-only.
Public property Rotation Returns or sets the rotation of the shape in degrees. Read/write Single.
Public property Shadow True if the font is a shadow font or if the object has a shadow. Read/write Boolean.
Public property ShapeStyle Returns or sets a MsoShapeStyleIndex that represents shape style for a shape range. Read/write.
Public property SoftEdge Returns an object that contains soft edge formatting properties for a specified shape range. Read-only.
Public property TextEffect Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to ShapeRange objects that represent WordArt. Read-only.
Public property TextFrame Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape range. Read-only.
Public property TextFrame2 Returns an object that contains text formatting for the specified shape range. Read-only.
Public property ThreeD Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only.
Public property Title Gets or sets the title of the alternative text associated with the specified shape range.
Public property Top The distance from the top edge of the topmost shape in the shape range to the top edge of the worksheet. Read/write Single.
Public property Type Returns or sets the shape type. Read-only MsoShapeType.
Public property VerticalFlip True if the specified shape is flipped around the vertical axis. Read-only MsoTriState.
Public property Vertices Returns the coordinates of the specified freeform drawing's vertices (and control points for Bézier curves) as a series of coordinate pairs. Read-only Object.
Public property Visible Determines whether the object is visible. Read/write MsoTriState.
Public property Width The width of the object. Read/write Single.
Public property ZOrderPosition Returns the position of the specified shape in the z-order. Read-only Integer.

Top

Methods

  Name Description
Public method _Default Reserved for internal use.
Public method Align Aligns the shapes in the specified range of shapes.
Public method Apply Applies to the specified shape formatting that’s been copied by using the PickUp method.
Public method CanvasCropBottom Reserved for internal use.
Public method CanvasCropLeft Reserved for internal use.
Public method CanvasCropRight Reserved for internal use.
Public method CanvasCropTop Reserved for internal use.
Public method Delete Deletes the object.
Public method Distribute Horizontally or vertically distributes the shapes in the specified range of shapes.
Public method Duplicate Duplicates the object and returns a reference to the new copy.
Public method Flip Flips the specified shape around its horizontal or vertical axis.
Public method GetEnumerator() (Inherited from IEnumerable.)
Public method GetEnumerator()
Public method Group Groups the shapes in the specified range. Returns the grouped shapes as a single Shape object.
Public method IncrementLeft Moves the specified shape horizontally by the specified number of points.
Public method IncrementRotation Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape.
Public method IncrementTop Moves the specified shape vertically by the specified number of points.
Public method Item Returns a single object from a collection.
Public method PickUp Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.
Public method Regroup Regroups the group that the specified shape range belonged to previously. Returns the regrouped shapes as a single Shape object.
Public method RerouteConnections Reroutes connectors so that they take the shortest possible path between the shapes they connect.
Public method ScaleHeight Scales the height of the shape by a specified factor.
Public method ScaleWidth Scales the width of the shape by a specified factor.
Public method Select Selects the object.
Public method SetShapesDefaultProperties Makes the formatting of the specified shape the default formatting for the shape.
Public method Ungroup Ungroups any grouped shapes in the specified shape or range of shapes. Disassembles pictures and OLE objects within the specified shape or range of shapes. Returns the ungrouped shapes as a single ShapeRange object.
Public method ZOrder Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order).

Top

See Also

Reference

ShapeRange Interface

Microsoft.Office.Interop.Excel Namespace