I have a Pivot table, where i need to add new row above the pivot table and show the subtotal of each column till last available Column. (Pivot range may vary)
Below is the code which i tried but it was not working correctly. Please help.
LR = ActiveSheet.Cells.Find("*"...