heres the SCENARIO>>>>>>
drop down menu choices are:
all fruits
orange
plum
ERROR HAPPENS WHEN I DO THIS>>>>
after one round of selection
from all fruits
then, oranges,
then plum ,
then back to all fruits again
then select orange I got that error.
QUESTION>>>>>>>>>>>>>>>
Is this about memory that excel can't handle? after one cylce it cant do it again?
is there a way to hide the error and push to the next step?
Expand|Select|Wrap|Line Numbers
- Sub Tree()
- Application.ScreenUpdating = False
- Sheet4.PivotTables("pivot_fruit1").PivotFields("tree"). _
- CurrentPage = Sheet20.Cells(10, 22).Value
- Sheet4.PivotTables(pivot_fruit_others1).PivotFields("tree"). _
- CurrentPage = Sheet20.Cells(10, 22).Value
- end sub