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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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
40
Invisibleman
I
F
  • Solved
Problems filtering a Pivot Table with VBA
Replies
2
Views
850
Domenic
D
A
  • Question Question
getting application defined error
Replies
3
Views
98
Domenic
D
M
  • Question Question
VBA: Filter Pivot table on 2 terms for the same field
Replies
0
Views
273
mikeymike123
M
M
  • Question Question
VBA Macro with option to filter Pivot Tables multiple times.
Replies
0
Views
653
Macro_nerd
M

Forum statistics

Threads
1,223,247
Messages
6,171,004
Members
452,374
Latest member
keccles

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