heii, i just begin access vba.
how glad i am when i found this, thanks for everything.
but, when i put your code and trying to run it, iam getting error " 1004 - Unable to get the pivotFields property of pivottable class ".
what must i do to solve it ?
any help to answer this i really...