Export (0) Print
Expand All
P
PivotCache Method
PivotCaches Method
PivotFields Method
PivotItems Method
PivotSelect Method
PivotTables Method
PivotTableWizard Method
Play Method
Points Method
PointsToScreenPixelsX Method
PointsToScreenPixelsY Method
Post Method
PresetDrop Method
PresetGradient Method
PresetTextured Method
Previous Method
PrevNode Method
PrintOut Method
PrintPreview Method
Protect Method
ProtectSharing Method
Publish Method
PurgeChangeHistoryNow Method
Expand Minimize

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.PickUp

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




Show:
© 2014 Microsoft