Hi
I have the next problem with Microssoft Office 2010:
I did a Macro with a PivotTable, but when I run the macro I get an error in the next senetence:
ActiveSheet.PivotTables("TD EBITDA").PivotFields("Subregion").CurrentPage = "(Todas)"
The error is: Run Time Error 1004: Error defined by object or aplication
I find that the error is in "(Todas)", because if I change this word by "(All)" the error don't happens.
I verified the lenguage, this is spanish in excel and windows, also I ran this code in excel 2007, but I did not get any error.
I Know that I can change this value, so I don't need to do this. Could somebody hep me?
Thanks
I have the next problem with Microssoft Office 2010:
I did a Macro with a PivotTable, but when I run the macro I get an error in the next senetence:
ActiveSheet.PivotTables("TD EBITDA").PivotFields("Subregion").CurrentPage = "(Todas)"
The error is: Run Time Error 1004: Error defined by object or aplication
I find that the error is in "(Todas)", because if I change this word by "(All)" the error don't happens.
I verified the lenguage, this is spanish in excel and windows, also I ran this code in excel 2007, but I did not get any error.
I Know that I can change this value, so I don't need to do this. Could somebody hep me?
Thanks