LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default How to read the current grouping of a pivotfield in a pivottable

I would like to read/save with VBA the current grouping of a
pivotfield (a date either grouped by month, quarter or year) so I can
restore it later via VBA.

Anyone an idea how I can read the current grouping of pivot field?

This is a code example how the grouping can be doen with VBA. But how
can I read the group status???
' Group Date by Month, Quarter, Year
pt.PivotFields("DetailDate").LabelRange.Group Start:=True, _
End:=True, periods:= _
Array(False, False, False, False, True, True, True)
 
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
Grab PivotField Data When Not in PivotTable DtTall Excel Programming 0 July 18th 07 07:12 PM
PivotTable grouping problem septillion Excel Discussion (Misc queries) 0 July 4th 06 01:58 AM
How to have a Macro skip code if PivotTable/PivotField is not there [email protected] Excel Programming 0 January 29th 06 11:38 AM
PivotTable, Pivotfield selective invisible, too slow MSN Excel Programming 0 November 11th 03 10:56 AM
Code for Grouping Text Values in Pivotfield Keith Young Excel Programming 1 July 17th 03 03:14 AM


All times are GMT +1. The time now is 04:48 PM.

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

About Us

"It's about Microsoft Excel"