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

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

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