The worksheet, pivot table or pivot field is missing?

--

Regards,
Nigel




"jmlozares" <u44951@uwe wrote in message news:87756b22bab9b@uwe...
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.