Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group and Outline by marco?
Hi all,
Is it possible to do group and outline by marco? Thank in advance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group and Outline by marco?
This is pasted from the VBA help on the 'group' method. There is also the
AutoOutline Method, Outline Object, ClearOutline Method, DisplayOutline Property, etc The Range object must be a single cell in the PivotTable field’s data range. If you attempt to apply this method to more than one cell, it will fail (without displaying an error message). Example This example groups the field named ORDER_DATE by 10-day periods. Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable Set groupRange = pvtTable.PivotFields("ORDER_DATE").DataRange groupRange.Cells(1).Group by:=10, _ periods:=Array(False, False, False, _ True, False, False, False) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "kaon " wrote in message ... Hi all, Is it possible to do group and outline by marco? Thank in advance. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
group and outline | Excel Discussion (Misc queries) | |||
Under data/Group&outline/group | Excel Discussion (Misc queries) | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Group and Outline | New Users to Excel | |||
Group and Outline | Excel Discussion (Misc queries) |