Shape.Apply Method (Excel)

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

expression .Apply

expression A variable that represents a Shape object.

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

Concepts

Other resources

Show:
© 2014 Microsoft