Hi All,

We bumped into the following problem in an excel workbook:
Put the following range in a pivot table.

brand qtr value
ps q1 23
ps q2 54
ps xm q1 43
ps xm q2 65

put qtr as column and brand as row

The following macro produce an error '1004'
Application-defined or object defined error and it looks as if "ps <anything>" causes the error.

Sub test()
Dim p As PivotTable
Dim b As Range

Set p = ActiveSheet.PivotTables("pivottable1")
p.PivotSelect "brand[all]", xlLabelOnly
Set b = Selection

For i = 1 To 2
p.PivotSelect b.Cells(i).Value, xlDataOnly
Next i

End Sub

Please help!!!!.
[email protected]