Create a PivotTable from a VBA array?

[Dave]

I've been trying to create a PivotTable from a VBA array. No dice.

The code works if I dump the VBA array to a Range and then use the Range as
the source but I'd like to avoid this intermediate step if possible.

Thanks

Dave