Hide Pivottable GrandTotal using VB

[johnb]

Hi Guys
I'm building a pivottable using ADO and VB and I need to hide the Grand
Totals both for colums and Rows. How do I do that in Code

TIA

johnb

 

[Roger Govier]

Hi John

With ActiveSheet.PivotTables("PivotTable1")
.ColumnGrand = False
.RowGrand = False
End With

 

[johnb]

Hi Roger
Thanks for the reply. Its so simple when you know the syntax.

Where do you find syntax?

Kind regards
johnb

 

[Roger Govier]

Hi John

The easiest way I find, is to record a short macro, then examine what gets
created.

 

[johnb]

Hi Roger

Thanks for the feedback

regards
johnb

Hi John

The easiest way I find, is to record a short macro, then examine what gets
created.