ShapeRange.PickUp Method (Excel)
Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.
Syntax
expression .PickUp
expression A variable that represents a 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