Debra Dalgleish has posted code to do this:
http://groups.google.co.uk/group/mic...900b96 680905

or


http://tinyurl.com/axk75


Kirk P. wrote:

Is there any way to suppress the display of blank cells within the data area
of a pivot table?

--

Dave Peterson