| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Shape.PickUp method (Excel) |
vbaxl10.chm636081 |
|
|
77da5d6d-35f8-71c3-70ee-481f59c5674b |
05/14/2019 |
medium |
Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.
expression.PickUp
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[!includeSupport and feedback]