PivotFilters.Add2

MNBUARQUE

New Member
Joined
Aug 27, 2014
Messages
3
Hi !!

What is the difference between
PivotFilters.Add2 and PivotFilters.Add

I have already recorded a pivot table filtering process and sometimes I've gotten a PivotFilters.Add2 recorded and sometimes i've gotten PivotFilters.Add

BR
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,496
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Add2 will only work in Excel 2013 (or later!). I'd guess either it's a filter unavailable in previous versions, or perhaps you're using the Data Model when the Add2 gets recorded.
 

MNBUARQUE

New Member
Joined
Aug 27, 2014
Messages
3
Add2 will only work in Excel 2013 (or later!). I'd guess either it's a filter unavailable in previous versions, or perhaps you're using the Data Model when the Add2 gets recorded.

Thanks a LOT RoryA ! it makes lots of sense;
When I record a filter in Excel 2013, sometimes, I get an Add2. And, if a try to run this recorded slice into excel 2010 it does not work at all !
Unfurtunatelly, on the oposit direction, when I replace a "add2" with a "add" , the macro works in Excel 2010 but stops working in Excel 2013 !!!!!

But....does somebody knows what is the difference between de new Add2 method and the old Add ?

BR
 

Watch MrExcel Video

Forum statistics

Threads
1,108,709
Messages
5,524,433
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top