Pivot Table

Hi Sandip

To format a pivot table's data you need to decide which format to use, then you write the following code:


Sheets("The Sheet").PivotTables("MyPivotTable").DataBodyRange.NumberFormat = "$#,##0"

If you want to group the row values you could also do the following (In this example there are dates in the row area):

Range("A4").Select
Selection.Group Start:=True, End:=True, Periods:=Array(False, False, False, _
False, True, False, False)

Regards

Carlos