View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
grant grant is offline
external usenet poster
 
Posts: 24
Default Worksheet_Change procedure question

Hi there,

I have a standard pivottable with a worksheet_change sub
procedure behind the sceens. When the user changes a page
field item then the worksheet_change procedure is invoked
and the range value called Target refers back to the
whole range of the entire pivottable.

What I want to get is only the page field that was
changed. Is there anyway to do this?

Thanks,
Grant.