Skip to content

Latest commit

 

History

History
48 lines (30 loc) · 1.11 KB

Excel.Slicer.Cut.md

File metadata and controls

48 lines (30 loc) · 1.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Slicer.Cut method (Excel)
vbaxl10.chm905090
vbaxl10.chm905090
Excel.Slicer.Cut
a8778661-612f-0031-78b0-d59bb87fdf62
05/16/2019
medium

Slicer.Cut method (Excel)

Cuts the specified slicer and copies it to the clipboard.

Syntax

expression.Cut

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

[!includeSupport and feedback]