Thread: How to know which pivotFields was changed through Private Sub Worksheet_PivotTableUpdate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
magickarle magickarle is offline
external usenet poster
  
Posts: 18
Default How to know which pivotFields was changed through Private Sub Worksheet_PivotTableUpdate
Hi, I want to know the row pivotfields name where a user changes it's
items value.
IE: I got 2 row fields: day and month. I want to know if the user
changed a date or a month in the pivot table row.
So if the user changed from ALL the day row fields to "jan 01", a
function would return "day"
Thanks

Reply With QuoteReply With Quote