"Stephen Wortley" wrote in message
om...

As a slight digression on this query, do people find that they stick
to using Pivot Tables whilst coding in VBA, or is using
Array(s)/Collection(s) also considered/acceptable?

I have always had difficulty working Pivot Tables, so when coding I
tend to use multidimensional arrays.

Are Arrays quicker - processing-wise - than Pivot Tables? Is there a
good reason why I should not use Arrays?

TIA

Stephen Wortley


I can only answer specifically for the one occasion I had to do this,
but in that situation the end users wanted the ability to drill down,
in the pivot table in the output worksheet, to see the underlying data
for a given result.

They wanted a pivot table so that is what they got. I guess that
using arrays / collections would not result in an output that normal
users could 'play' with. Whether that is a good or bad thing probably
depends on the situation!

HTH,

Alan.