Posted to microsoft.public.excel.programming

jmlozares

external usenet poster

Posts: 1

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Function Error?	Jackson[_3_]	Excel Worksheet Functions	3	February 19th 12 01:30 PM
Function Error	Diane	Excel Discussion (Misc queries)	4	June 12th 09 06:16 PM
Excel - User Defined Function Error: This function takes no argume	BruceInCalgary	Excel Programming	3	August 23rd 06 08:53 PM
If error function	Neil M	Excel Worksheet Functions	6	April 26th 06 06:56 PM
Function Error	Rhonda[_3_]	Excel Programming	3	December 11th 03 05:34 PM

All times are GMT +1. The time now is 01:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us