Anyone who can help me with this,

I have this problem and this is the screnario:

On a pivot table ("Pivot1") the ColumnField ("Month") refers to a dat
with Month format (1-12). I would like to retrieve the data to
MonthName format ("mmm"). My code goes like this but doesn't work:

With .PivotFields("Month")
.Subtotals = Array(False, False, False, False, False, False
False, False, False, False, False, False)
.PivotItems("(blank)").Visible = False
.AutoSort xlAscending, "Month"
.function = format(Monthname( ,true),"mmm")

End With


Thanks and more power!!

--
Message posted from http://www.ExcelForum.com