visible item

  1. Gabriel222

    Getting “Type Mismatch” with VBA PivotTables and Filter Dates

    Goal: To filter each "pre-structured" pivot table with different ranges of dates, (the ranges are all continuous), the pivot tables are connected to a Tabular OLAP Cube Script Description : In the script, (full script at the bottom of the post) I loop through the Years and then the Quarters...
    • Gabriel222
    • Thread
    • dim_array pivot table pivot table filter date vba visible item
    • Replies: 0
    • Forum: Excel Questions
  2. W

    Cannot count visible items in filtered pivot table correctly

    Hi, I have an issue with pivot tables, that's bugging me. I cannot get the correct count of visible items in pivot tables after changing the filters via VBA. Here is the code, that should grab every pivot table that has more than 1 row in the data body range: Sub changePTfilter(ws As Worksheet...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top