XLA routines: EE_PivotRemoveTotals

EE_PivotRemoveTotals is a simple routine that removes the totals from a pivot
Sub EE_PivotRemoveTotals(Optional pt As PivotTable) 'http://excelexperts.com/xla-routines-eePivotRemoveTotals for updates on this routine If pt Is Nothing Then If ActiveSheet.PivotTables.Count = 0 Then Exit Sub Set pt = ActiveSheet.PivotTables(1) End If pt.RowGrand = False pt.ColumnGrand = False End Sub
»
- Nick's blog
- Login or register to post comments
- 10064 reads
Recent comments
6 years 1 week ago
6 years 39 weeks ago
6 years 51 weeks ago
7 years 1 week ago
7 years 2 weeks ago
7 years 8 weeks ago
7 years 16 weeks ago
7 years 17 weeks ago
7 years 17 weeks ago
7 years 17 weeks ago