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

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/