View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jmlozares jmlozares is offline
external usenet poster
 
Posts: 1
Default 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.