J
Jim
I have an Excel 2003 pivot table with 4 page fields. In a macro I set the
CurrentPage property of one or more of these fields to certain fixed values
and attempt to retrieve data. Everything works fine until I try a value that
doesn't exist for a page field, upon which I get a VBA 400 error/crash. I
have tried unsuccessfully to use an ON ERROR GOTO sequence to trap the error.
CurrentPage property of one or more of these fields to certain fixed values
and attempt to retrieve data. Everything works fine until I try a value that
doesn't exist for a page field, upon which I get a VBA 400 error/crash. I
have tried unsuccessfully to use an ON ERROR GOTO sequence to trap the error.