Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - filter by a cell reference
Hmm. Also, try using a string value instead of a range.
Dim strTitleSelection As String strTitleSelection = Worksheets("Control Sheet").Range("JnlCode").Value ActiveSheet.PivotTables("PivotTable3").PivotFields ("Title #2").CurrentPage = strTitleSelection Hope that helps, -jeff "Matthew Balch" wrote: 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) | |||
Pivot Table - filter by a cell reference | Excel Programming |