PickUp Method

Applies To

Shape object, ShapeRange collection object.

Description

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

Syntax

expression.PickUp

expression Required. An expression that returns a Shape or ShapeRange object.

Example

This example copies the formatting of shape one on myDocument and then applies the copied formatting to shape two.

Set myDocument = Worksheets(1)
With myDocument
    .Shapes(1).PickUp
    .Shapes(2).Apply
End With