Hiding grand total column in a pivot table using VBA/Macro

**Anjana1811** · 08-23-2012, 03:02 PM

Hi,

I have the following code to create a pivot table. I want to hide the grand total for rows in the pivot. Can somebody please help m with the code?

Please Login or Register  to view this content.

Thanks

**taps** · 08-24-2012, 05:39 AM

Hi Anjana,

Welcome in Excel Forum.

Use below code in your macro. You need to modify the the pivot table name in your code.

Please Login or Register  to view this content.

**Anjana1811** · 08-24-2012, 10:42 AM

I tried that...Its not working!

**taps** · 08-24-2012, 12:09 PM

Hi,

Please show me the rectified code. Also let us know where the code is breaking?

**Anjana1811** · 08-24-2012, 01:41 PM

Please Login or Register  to view this content.

Bolded the part where the code is breaking..
Thak You!

---------- Post added at 12:41 PM ---------- Previous post was at 12:40 PM ----------

I used
.RowGrand = False
Was trying out something else and copied that in my previous post.

**Cutter** · 08-24-2012, 02:08 PM

@ Anjana1811

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.