Insert a blank row in a Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Blank Rows when Pivot Table included on sheet 3
Unable to Group in Pivot Table 1
Re-Linking Pivot tables to MS Query 2
List of Displayed Pivot Items 1
create a pivot table and chart from a named range 1
Excel 2010 Pivot Table 2
code to delete all rows beneath and columns right of pivot table 3
Playing back a Pivot Table macros 2

Back
Top