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