PivotTable

J

John Pierce

In the VBA code to generate a PivotTable, I have lines that say

..PivotItems("1/18/2009").Visible = False
..PivotItems("1/22/2009").Visible = False

Can I replace them with something that says don't show anything less
than a certain age
like don't show if item (date) is greater than Today() - 7.?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter PivotTable Field by VBA 1
delete selection in pivotcolumn 3
Controlling Pivotitems.visible 0
PivotTable 2003 Code is not working 0
Dynamic Pivot Item Selection 1
Pivot Table - How do I "Show All Data" of a particular field? 6
Controlling Pivotitems.visible 0
Pivot Tables using VBA 0

Top