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