Error Using the PivotFilters function
hi to all!
I'm just new in pivottable programming in excel. I can't get to work the
PivotFilters function, the statement is written as:
shtWorksheet.PivotTables(1).PivotFields(23).PivotF ilters.Add Type:
=xlValueIsBetween, Value1:="101"
running this statement causes me an error saying:
Runtime error 1004, Application-define or Object defined error.
Thanks in advance for replies.
|