| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a blank row in a Pivot table
Hi all
I'd like to insert a blank row after each subtotal using vb code in pivot table. All the books I've look at don't talk about it. Is it possible?? TIA johnb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a blank row in a Pivot table
Hi John
Sub test() ActiveSheet.PivotTables("PivotTable1").PivotFields ("Name") _ ..LayoutBlankLine = True End Sub For Pivot Fields, insert the name of the field which has Subtotals set and change the Pivot table name to suit. Setting the value to False will remove the blank line. -- Regards Roger Govier "johnb" wrote in message ... Hi all I'd like to insert a blank row after each subtotal using vb code in pivot table. All the books I've look at don't talk about it. Is it possible?? TIA johnb |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert a blank row in a Pivot table
Cheers Roger
"johnb" wrote: Hi all I'd like to insert a blank row after each subtotal using vb code in pivot table. All the books I've look at don't talk about it. Is it possible?? TIA johnb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table (blank) | Excel Discussion (Misc queries) | |||
| Pivot Chart Created from Pivot Table is Blank | Charts and Charting in Excel | |||
| pivot table (blank) vs. __ | Excel Discussion (Misc queries) | |||
| Pivot table creates blank table | Charts and Charting in Excel | |||
| Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
