共用方式為


ShapeRange Members (Excel)

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

Methods

Name

Description

Align

Aligns the shapes in the specified range of shapes.

Apply

Applies to the specified shape formatting that’s been copied by using the PickUp method.

Delete

Deletes the object.

Distribute

Horizontally or vertically distributes the shapes in the specified range of shapes.

Duplicate

Duplicates the object and returns a reference to the new copy.

Flip

Flips the specified shape around its horizontal or vertical axis.

Group

Groups the shapes in the specified range.

IncrementLeft

Moves the specified shape horizontally by the specified number of points.

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.

IncrementTop

Moves the specified shape vertically by the specified number of points.

Item

Returns a single object from a collection.

PickUp

Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.

Regroup

Regroups the group that the specified shape range belonged to previously. Returns the regrouped shapes as a single Shape object.

RerouteConnections

This method reroutes all connectors attached to the specified shape; if the specified shape is a connector, it’s rerouted.

ScaleHeight

Scales the height of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height.

ScaleWidth

Scales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width.

Select

Selects the object.

SetShapesDefaultProperties

Makes the formatting of the specified shape the default formatting for the shape.

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.

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).

Properties

Name

Description

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.

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.

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

AutoShapeType

Returns or sets the shape type for the specified Shape or ShapeRange object, which must represent an AutoShape other than a line, freeform drawing, or connector. Read/write MsoAutoShapeType.

BackgroundStyle

Returns or sets the background style. Read/write MsoBackgroundStyleIndex.

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.

Callout

Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to a ShapeRange object that represents line callouts. Read-only.

Chart

Returns a Chart object that represents the chart contained in the shape range. Read-only.

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.

ConnectionSiteCount

Returns the number of connection sites on the specified shape. Read-only Long.

Connector

True if the specified shape is a connector. Read-only MsoTriState.

ConnectorFormat

Returns a ConnectorFormat object that contains connector formatting properties. Applies to a ShapeRange objects that represent connectors. Read-only.

Count

Returns a Long value that represents the number of objects in the collection.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Fill

Returns a FillFormat object for a specified shape or a ChartFillFormat object for a specified chart that contains fill formatting properties for the shape or chart. Read-only.

Glow

Returns a GlowFormat object for a specified shape range that contains glow formatting properties for the shape range. Read-only.

GroupItems

Returns a GroupShapes object that represents the individual shapes in the specified group. Use the Item method of the GroupShapes object to return a single shape from the group. Applies to ShapeRange objects that represent grouped shapes. Read-only.

HasChart

Returns whether a shape range contains a chart. Read-only MsoTriState.

Height

Returns or sets a Single value that represents the height, in points, of the object.

HorizontalFlip

True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState.

ID

Returns a Long value that represents the type for the specified object.

Left

Returns or sets a Single value that represents the distance, in points, 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).

Line

Returns a LineFormat object that contains line formatting properties for the specified shape. (For a line, the LineFormat object represents the line itself; for a shape with a border, the LineFormat object represents the border). Read-only.

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.

Name

Returns or sets a String value representing the name of the object.

Nodes

Returns a ShapeNodes collection that represents the geometric description of the specified shape.

Parent

Returns the parent object for the specified object. Read-only.

ParentGroup

Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes.

PictureFormat

Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to a ShapeRange object that represent pictures or OLE objects. Read-only.

Reflection

Returns a ReflectionFormat object for a specified shape range that contains reflection formatting properties for the shape range. Read-only.

Rotation

Returns or sets the rotation of the shape, in degrees. Read/write Single.

Shadow

Returns a read-only ShadowFormat object that contains shadow formatting properties for the specified shape or shapes.

ShapeStyle

Returns or sets an MsoShapeStyleIndex object that represents the shape style of the shape range. Read/write.

SoftEdge

Returns a ReflectionFormat object for a specified shape range that contains soft edge formatting properties for the shape range. Read-only.

TextEffect

Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Read-only.

TextFrame

Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only.

TextFrame2

Returns a TextFrame2 object that contains text formatting for the specified shape range. Read-only.

ThreeD

Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only.

Title

Returns or sets the title of the alternative text associated with the specified shape range. Read/write

Top

Returns or sets a Single value that represents the distance, in points, from the top edge of the topmost shape in the shape range to the top edge of the worksheet.

Type

Returns an MsoShapeType value that represents the shape type.

VerticalFlip

True if the specified shape is flipped around the vertical axis. Read-only MsoTriState.

Vertices

Returns the coordinates of the specified freeform drawing's vertices (and control points for Bézier curves) as a series of coordinate pairs. You can use the array returned by this property as an argument to the AddCurve method or AddPolyLine method. Read-only Variant.

Visible

Returns or sets an MsoTriState value that determines whether the object is visible. Read/write.

Width

Returns or sets a Single value that represents the width, in points, of the object.

ZOrderPosition

Returns the position of the specified shape in the z-order. Read-only Long.