Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyone knows PivotTable about "Select multiple items"(Urg
I am programming in Excel Macro with VBA, Is there anyone know how to deal
with "Select Multiple items" in page area. i.e.: In page area, there is product dimension. In Excel 2003, PivotTable provides "Select Multiple Items" feature in page area. I want to select more products A ,B ,C. I should use "Select multiple items". Is there any object to provide this feature to catch these values? -- Developer QA Dashboard Microsoft China Development Centre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyone knows PivotTable about "Select multiple items"(Urg
You can add an item to the currently selected items, e.g.:
With ActiveSheet.PivotTables(1).PivotFields("[Dept]") .CubeField.EnableMultiplePageItems = True .AddPageItem "[Dept].[All].[Finance]" End With Microlong wrote: I am programming in Excel Macro with VBA, Is there anyone know how to deal with "Select Multiple items" in page area. i.e.: In page area, there is product dimension. In Excel 2003, PivotTable provides "Select Multiple Items" feature in page area. I want to select more products A ,B ,C. I should use "Select multiple items". Is there any object to provide this feature to catch these values? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyone knows PivotTable about "Select multiple items"
hi, Debra Dalgleish:
I want to catch the Values which enable Select Multiple item. I should get these values. My application raise err.Number runtime error 438 ,err.descripton : object doesn't support this property or method. I use pcell.PivotTable.Pivotfields object? which object or method supports this? Do you know ? "Debra Dalgleish" wrote: You can add an item to the currently selected items, e.g.: With ActiveSheet.PivotTables(1).PivotFields("[Dept]") .CubeField.EnableMultiplePageItems = True .AddPageItem "[Dept].[All].[Finance]" End With Microlong wrote: I am programming in Excel Macro with VBA, Is there anyone know how to deal with "Select Multiple items" in page area. i.e.: In page area, there is product dimension. In Excel 2003, PivotTable provides "Select Multiple Items" feature in page area. I want to select more products A ,B ,C. I should use "Select multiple items". Is there any object to provide this feature to catch these values? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Items in Report Filter of PivotTable not "checked" automatically | New Users to Excel | |||
How do I move a document from "recent items" to "documents" | New Users to Excel | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Convert "Month" to "MonthName" format from db to PivotTable | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |