Creating pivot table with VBA

Posted to microsoft.public.excel.programming

ecctse

external usenet poster

Posts: 5

Creating pivot table with VBA

Hi,

I am trying to create a pivot tables using VBA with different number of rows
of source data. How can I supply the number of rows as a parameter to the
following method:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:="???"

It seems it doesn't like me to supply a string variable to the SourceData,
for example, SourceData:= strRange

Any other method to get around? Thanks.

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
How can I detail Pivot Table data without creating a table (Excel2007)	Skeletiko[_2_]	Excel Discussion (Misc queries)	1	May 5th 10 08:22 AM
How can I detail Pivot Table data without creating a table (Excel2007)	Skeletiko	Excel Discussion (Misc queries)	0	May 5th 10 12:21 AM
creating a report from a table, pivot table not suitable	UKMAN	Excel Worksheet Functions	1	April 16th 10 08:35 AM
creating a pivot table from 4 pivot tables	phyllis W	Excel Worksheet Functions	0	October 12th 08 09:52 PM
Creating Pivot Table with VBA	Eric Lecocq	Excel Programming	2	December 11th 03 01:53 PM

All times are GMT +1. The time now is 02:43 PM.

Menu

About Us