Shape.Apply Method

  • Article
Excel Developer Reference

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

Syntax

expression.Apply

expression   A variable that represents a Shape object.

Example

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

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument
    .Shapes(1).PickUp
    .Shapes(2).Apply
End With

See Also