Hi All,
I recorded the below macro, but I cannot get it running. I did nothing to the original recorded code. I tried looking through the forums cannot cannot find a solution around it.
Please help to see what went wrong with this code?
- The pivot table is created with Data model
- I wanted to select "Vendor A" in column field so that I can draw a border around it.
Sub Macro12()
ActiveSheet.PivotTables("PivotTable1").PivotSelect _
"'[Range].[Release Location].[Release Location]'['[Range].[Release Location].&[LLL]']" _
, xlDataAndLabel, True
End Sub
Bookmarks