This documentation is archived and is not being maintained.

PickUp Method [Excel 2003 VBA Language Reference]

Office 2003

Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.


expression Required. An expression that returns a Shape or ShapeRange 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
End With