Hi Excel Guru, I have a quick question; what is the code to remove the check mark on the "Insert blank line after each item" from the PivotTable Field Layout - Display Options My code is NOT working With Sheets("Deficiency Report").PivotTables("Felix2").PivotFields("Provider") .Orientation = xlRowField .Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False) .LayoutBlankLine = False .Position = 1 End With

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Code for the PivotTable Field Layout

Thread starter fpskidmark
Start date May 20, 2011

fpskidmark

Board Regular

May 20, 2011

Hi Excel Guru,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

>
<o

></o

>
I have a quick question; what is the code to remove the check mark on the "Insert blank line after each item" from the PivotTable Field Layout - Display Options<o

></o

>
<o

></o

>
My code is NOT working<o

></o

PHP:

      With Sheets("Deficiency Report").PivotTables("Felix2").PivotFields("Provider")
        .Orientation = xlRowField
        .Subtotals = Array(False, False, False, False, False, False, False, False, False, False, False, False)
        .LayoutBlankLine = False
        .Position = 1
    End With