esvetalalala
New Member
- Joined
- May 29, 2012
- Messages
- 20
hello! i receive a pivot-report which i need to modify to retrieve information and i pretty much can handle that in vba but there are various filters that need to be applied. my question is
how can i make vba code to check whether certain filter/field is applied (unticked) and do nothing. this would ease my job so much!
this is a piece of code i have... even that throws me error msg that 'new' not found.... dont know why
'Vlookup New is' pivot field and 'New' is my keyword that i need to filter out. with similar instances i get a report with a keyword is sometimes ticked or unticked...
piv.Activate
ActiveSheet.PivotTables("PivotTable2").PivotFields("Vlookup New"). _
ClearAllFilters
ActiveSheet.PivotTables("PivotTable2").PivotFields("Vlookup New").CurrentPage _
= "New"
I'm a vba beginner... any helps is appreciated!
how can i make vba code to check whether certain filter/field is applied (unticked) and do nothing. this would ease my job so much!
this is a piece of code i have... even that throws me error msg that 'new' not found.... dont know why
'Vlookup New is' pivot field and 'New' is my keyword that i need to filter out. with similar instances i get a report with a keyword is sometimes ticked or unticked...
piv.Activate
ActiveSheet.PivotTables("PivotTable2").PivotFields("Vlookup New"). _
ClearAllFilters
ActiveSheet.PivotTables("PivotTable2").PivotFields("Vlookup New").CurrentPage _
= "New"
I'm a vba beginner... any helps is appreciated!