Unfortunately I get a 1004 Runtime error with the following msg:

"Unable to set the CurrentRange property of the PivotField class"