Slicer.Cut method (Excel)
Cuts the specified slicer and copies it to the clipboard.
expression A variable that represents a Slicer object.
The following code example accesses the Customer slicer by using the Range property of the Shapes collection, and then cuts and pastes it into the active worksheet.
ActiveSheet.Shapes.Range(Array("Customer")).Select Selection.Cut ActiveSheet.Paste
Alternatively, you can perform the same operation by using the Slicers property of the SlicerCache object to access the slicer, as shown in the following code example.
ActiveWorkbook.SlicerCaches("Slicer_Customer") _ .Slicers("Customer").Cut ActiveSheet.Paste
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.