Slicer.Copy Method (Excel)
Copies the specified slicer to the clipboard.
Version Information
Version Added: Excel 2010
Syntax
expression .Copy
expression A variable that represents a Slicer object.
Example
The following code example accesses the Customer slicer by using the Range property of the Shapes collection, and then copies and pastes it into the active worksheet.
ActiveSheet.Shapes.Range(Array("Customer")).Select
Selection.Copy
ActiveSheet.Paste
Alternatively, you can perform the same operation by using the Slicers property of the SlicerCaches collection to access the slicer, as shown in the following code example.
ActiveWorkbook.SlicerCaches("Slicer_Customer") _
.Slicers("Customer").Copy
ActiveSheet.Paste