On Mar 14, 2:36*pm, darkblue wrote:
Thank you AB. I think i'd better stick to my current method.
Hide the colums where the pivot table resides on and move everything
somewhere else.
And thank you Don for your kind offer.
Rgds

Let's see you ask for solutions that you doin't use. As long as your
are happy....