Nothing keyword Archives - ExcelBaby

Learn

Excel Macro: Adjust All Pivot Data Field Titles

When you create a PivotTable, Excel prefixes the title of each data field with Sum of, Count of. If you want the […]

PivotField.Caption property PivotField.SourceName property Is operator PivotTable.Name property Chr function Nothing keyword For Each...Next statement On Error statement

Learn

Excel Macro: Hide All Subtotals in a PivotTable

This simple macro hides all subtotals in the specified PivotTable. Tips You can manually hide all subtotals at once by going to […]

Is operator PivotTable.Name property Nothing keyword For Each...Next statement On Error statement

Docs

Nothing keyword

The Nothing keyword is used to disassociate an object variable from an actual object. Use the Set statement to assign Nothing to […]

Nothing keyword