Hello Everyone, I am trying to get vba code using record macro to click “Do not show subtotal” [image] When I do record macro, it gives code like this [image] Can anyone provide a better solution to this?

Hi @Mohammad.Fuad Try this: Sub DoNotShowSubtotal() Dim ws As Worksheet Dim rng As Range Set ws = ThisWorkbook.Sheets("Sheet1") Set rng = ws.Range("A1:D10") rng.Subtotal GroupBy:=1, Function:=xlNone, TotalList:=Array(1), _ Replace:=False, PageBreaks:=False, Summary…

VBA code to perofrm "do not show subtotal"

Help Studio

mkankatala (Mahesh Kankatala) February 5, 2024, 10:23am 2

Hi @Mohammad.Fuad

Check the below thread for better understanding,

Hope it helps!!

Topic		Replies	Views
Hide subtotal and classic view in pivot table using VB Help studio , error	1	1361	September 17, 2019
Excel Subtotal Help	1	1642	July 9, 2018
Removing Subtotals from Pivots Studio studio , question , workflow_diff	10	652	February 3, 2024
Implementing Subtotals Studio studio , question , designer_canvas	4	1125	July 19, 2021
Invoke VBA macro issue Studio studio , question , output_panel	2	50	September 4, 2024

VBA code to perofrm "do not show subtotal"

Related topics