vba数据透视表（Vba PivotTable）.docVIP

vba数据透视表（Vba PivotTable） Use VBA to create PivotTable, excel PivotTable, 2008-04-18 17:01:56, read 331 comment, 0: big, medium, small I. how to create a PivotTable with the PivotTable wizard: Worksheets (Sheet2), .PivotTableWizard SourceType:=xlDatabase, SourceData:=Range (Sheet1, A4:E250) Use the PivotTableWizard method to create a PivotTable, 2 parameters, a SourceType type of data source, using the Excel database; another SourceData data source, the work table Sheet1! The cell area A4:E250, the PivotTable position in the current activities of the cell. Of course, you can also specify a deta