| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible PivotItems matching criteria
How can I use -
With ActiveSheet.PivotTables("PivotTable1").PivotFields ("Ref") ..PivotItems("QM").Visible = True What I want to do is show anything that matches QM (i.e. "QM - 1" or "QM - 2") Any ideas, I can't use a * or LIKE in the code can I? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Controlling Pivotitems.visible | Excel Discussion (Misc queries) | |||
| Pivot Change PivotItems - Visible/Hide with VBA | Excel Worksheet Functions | |||
| Always keep the same 4 PivotItems visible | Excel Programming | |||
| PivotItems.Count is 0 when items are visible on the sheet | Excel Programming | |||
| Excel Pivot Tables, Page Fields, Visible PivotItems, Activation | Excel Programming | |||
Threaded Mode
