Thread: PivotTable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Pierce John Pierce is offline
external usenet poster
  
Posts: 93
Default PivotTable
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.?
Reply With QuoteReply With Quote