ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet_Change procedure question (https://www.excelbanter.com/excel-programming/311770-worksheet_change-procedure-question.html)

grant

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.


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com