Create a PivotTable from a VBA array?

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a listbox as a dynamic array? 9
New computer, how do i move outlook 365 ENTIRELY? 0
Array to Multiple Arrays 3
Creating an ARRAY UDF 0
Dynamic Creation of Arrays - Sorting into Bins problem 2
Search an array of sheets for an array of numbers & return count of numbers 11
Slight VBA hickup 3
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0

Top