|
我自己录制的一个透视宏,但是运行报错。代码如下:
Sub 透视()
'
' 透视 Macro
' 宏由 3 录制,时间: 2013/3/8
'
' 快捷键: Ctrl+t
'
Cells.Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"C8205A!C1:C22").CreatePivotTable TableDestination:="", TableName:="数据透视表1" _
, DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveSheet.PivotTables("数据透视表1").AddFields RowFields:="部品番号"
With ActiveSheet.PivotTables("数据透视表1").PivotFields("剩余数")
.Orientation = xlDataField
.Caption = "求和项:剩余数"
.Function = xlSum
End With
End Sub
红色这段是报错部分,应该怎么修改?谢谢!
- Sub 创建数透表()
- Dim rg As Range
- Dim pvc As PivotCache
- Dim strMsg As String
- With Worksheets("C8205A")
- Set rg = .Range("a1").CurrentRegion
- Set pvc = ThisWorkbook.PivotCaches.Create(xlDatabase, rg)
- End With
-
- Worksheets.Add
- With pvc.CreatePivotTable(Range("c8"))
- .AddFields RowFields:="部品番号"
- .CompactLayoutRowHeader = "部品番号"
- .AddDataField .PivotFields("剩余数"), "剩余数求和"
- strMsg = .Name & " 创建在 " & ActiveSheet.Name
- End With
- MsgBox strMsg
- End Sub
复制代码
|
|