This topic has not yet been rated - Rate this topic

ShapeRange.Apply Method (Excel)

Published: July 16, 2012

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

expression .Apply

expression A variable that represents a 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 
 .Shapes(1).PickUp 
 .Shapes(2).Apply 
End With

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.