View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Slim Slender[_2_] Slim Slender[_2_] is offline
external usenet poster
 
Posts: 39
Default Filter PivotTable Field by VBA

Does anyone know how to 'generalize' the following:

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

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