Thread: How do I change the date in a pivot table pagefield using VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
st st is offline
external usenet poster
  
Posts: 3
Default How do I change the date in a pivot table pagefield using VBA
My pivot table shows one day's worth of data. I have multiple
departmenst in the rows, and 3 categories of expenditures in the
columns. I use the Page area to show a date. How do I use VBA to
change the date to today()-1 (yesterday).

Thanks
Reply With QuoteReply With Quote