-
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]
-
Which version ???
...but excel itself is a bug !! :-)
-
We are running Excel version 97
Thx.
Abie