Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - filter by a cell reference
Hi Matthew,
I'm kind of new to programming pivot tables myself, so this is guess, but have you tried using the Name property? ActiveSheet.PivotTables("PivotTable3").PivotFields ("Title #2").CurrentPage.Name = TitleSelection -jeff Hi, I am having trouble with some VB where I want to filter a pivot table based upo na cell value. Here's the problem bit ofVB I have:- Dim TitleSelection As Range Set TitleSelection = Worksheets("Control Sheet").Range("JnlCode") ActiveSheet.PivotTables("PivotTable3").PivotFields ("Title #2").CurrentPage = TitleSelection I.e. where I have = TitleSelection doesn't work. Thanks in advance Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking a pivot table filter to a control cell | Excel Discussion (Misc queries) | |||
PIVOT - Reference a cell outside the table for report filtering | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |