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.

Error Using the PivotFilters function
 

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.

Error Using the PivotFilters function
 

Thanks nigel!

I was able to solve my problem. I've used the Visible property of the
PivotItem object instead.

Regards,
Jan


Nigel wrote:
The worksheet, pivot table or pivot field is missing?

hi to all!

[quoted text clipped - 9 lines]

Thanks in advance for replies.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200807/1