Brandon.Charlesworth
New member
- Joined
- Mar 16, 2011
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hey,
I am a little rusty with vba these days.
I am trying to filter my pivot table by linking it to a cell on a seperate worksheet. This is what I have but I keep getting an error message. I am using excel 2007.
Thanks!,
Brandon
I am a little rusty with vba these days.
I am trying to filter my pivot table by linking it to a cell on a seperate worksheet. This is what I have but I keep getting an error message. I am using excel 2007.
Code:
Sub Tourname()
'
' To filter PT by tour
'
'
wrkshtpt.PivotTables("PivotTable1").PivotFields("Tour name").ClearAllFilters
wrkshtpt.PivotTables("PivotTable1").PivotFields("Tour name").Sheets("wrkshtcmw").Range ("B1")
End Sub
Thanks!,
Brandon