Excel 2007 : pivotfilters.add method

[VICHI]

hi

'ptable is pivot table
TEST = "D1" 'defined as string

With PTABLE.PivotFields("DESIGN_CODE")
.ClearLabelFilters
.PivotFilters.Add Type:=xlCaptionContains, Value1:=TEST 'this line gives me application defined error
End With

could some one pls help me with this code.......cant figure out wats wrong
thnks in advance
vichi

[VICHI]

hi

'ptable is pivot table
TEST = "D1" 'defined as string

With PTABLE.PivotFields("DESIGN_CODE")
.ClearLabelFilters
.PivotFilters.Add Type:=xlCaptionContains, Value1:=TEST 'this line gives me application defined error
End With

could some one pls help me with this code.......cant figure out wats wrong
thnks in advance
vichi

any suggestion guys pls help!!!