Create a PivotTable from a VBA array?

Posted to microsoft.public.excel.programming

Dave[_15_] Dave[_15_] is offline

external usenet poster

Posts: 11

Create a PivotTable from a VBA array?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTable field name is not valid - cannot create	shineOn	Excel Discussion (Misc queries)	1	January 16th 08 01:48 PM
Creating a PivotTable w/o selecting data in an existing PivotTable	Damian	Excel Discussion (Misc queries)	6	November 2nd 07 04:44 PM
Create a Pivottable in a macro	Michael	Excel Discussion (Misc queries)	8	March 15th 07 02:41 PM
Can I create PivotTable formula using count of field not sum?	Clip	Excel Discussion (Misc queries)	0	November 7th 06 01:31 AM
function to reference all of pivottable data field array	andrew	Excel Worksheet Functions	0	February 22nd 06 05:54 PM

All times are GMT +1. The time now is 08:58 PM.

Menu

About Us