VBA, Using Conceptual Filters in PivotTables

A

aallaman

New Member
Joined
Dec 4, 2009
Messages
44
Hi All,

I'm trying to get my pivot table to respond to a VBA command to filter based on a xlValueIsNotBetween filter type. But I keep getting a Run-time Error '1004': Application-defined or object-defined error

Here is the code I'm using. Can anyone give me pointers on why this isn't working???

PT.PivotFields("% Over/Under Spend").PivotFilters.Add Type:=xlValueIsNotBetween, _
Value1:=-0.1, Value2:=0.1
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Hi ,

"Can I do it manually?" Good point. Just checked and I cannot. The filter only lets me filter the 'top ten' not the other conceptual filters.

Why would those filters be disabled?

Is there any work around?

Thanks

Allen
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Solved
Pivot filter on date with xlAfterOrEqualTo and xlAfter and others generate error
Replies
1
Views
78
Invisibleman
I
F
  • Solved
Problems filtering a Pivot Table with VBA
Replies
2
Views
875
Domenic
D
A
  • Question Question
getting application defined error
Replies
3
Views
114
Domenic
D
M
  • Question Question
VBA: Filter Pivot table on 2 terms for the same field
Replies
0
Views
300
mikeymike123
M
M
  • Question Question
VBA Macro with option to filter Pivot Tables multiple times.
Replies
0
Views
721
Macro_nerd
M

Forum statistics

Threads
1,224,590
Messages
6,179,758
Members
452,940
Latest member
rootytrip

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top