Hello,
I have a macro that apply pivot table to my array, the only issue in code is that the data in this table changes. Since I have recorded macro that filters the some items it gives me an error when second time that item is not availble to filter. i.e.
.PivotItems("C").Visible = False
All I want to do here is that no matter if this item "C" available or not macro should do its work
Attached is the workbook with an example, your help will be highly appreciated.
Please let me know.
Thanks!
Sandeep
Bookmarks