Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Returning actual page field changed in pivottable

Hi there,

Is there any way to return the actual page field that was
changed from the Private Sub Worksheet_Change(ByVal
Target As Range) procedure?

The value Target returns is the entire range of the
pivottable, not just the page field range cell that was
changed.

Any ideas?

Grant.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotTable - how do I hide page field when printing Celia Excel Discussion (Misc queries) 2 October 18th 06 09:46 PM
PivotTable - How to unhide page field items? Epinn New Users to Excel 3 October 16th 06 01:10 PM
Print tab for each page field in PivotTable Scott Hernandez Excel Discussion (Misc queries) 1 August 24th 06 03:38 PM
second axis disappears on pivot chart when page field changed paulbrown Charts and Charting in Excel 1 March 27th 06 01:49 PM
How do I refresh a PivotTable and remove outdated page field entr. NT Excel Discussion (Misc queries) 2 January 5th 05 09:39 PM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"