I've been searching through this group for similar problems (and found
one) but I was still unable to resolve the issue below. When I try to
set bigcache, it throws a type mismatch at me and I'll be damned if I
can work it out. Any help is much appreciated. My code is:


<snip
Dim bigcache As Variant

Have you tried making bigcache a PivotCache instead of a Variant?

Iain King