4 Replies Latest reply: May 12, 2014 2:36 PM by Beau Brenno RSS

    hide row in pivot table by macro

    Davide Ducco

      Hi all,

      Is there the possibility to hide a row in a pivot table like the column?


      private sub HideColumn(ch, n)

      set ch = ActiveDocument.GetSheetObject(ch)

      ch.SetPixWidth (n-1), 0


      I try to use SetPixHeight but with no result.

      Anyone can help me?


      Thanks all in advance,