highlight data in pivottable by using getpivotdata as reference RRS feed

  • Question

  • Hello guys,

    I am looking for a code that helps me highlight the selected data created by getpivotdata in the pivottables.

    I have 16 worksheets with pivottables and i have one "controllworksheet" where all the data is displayed via getpivotdata.

    My problem is i want to select all he getpivotdata cells in my controllworksheet and then run the code, which finds the used values through their adress from the getpivotdata in their pivottable and hightlight them.

    Hopefully some one can help me!!

    Thank you and greetings,


    Monday, March 9, 2020 9:57 AM