Posted to microsoft.public.excel.programming

JIM.H.[_2_] JIM.H.[_2_] is offline

external usenet poster

Posts: 10

SourceData in pivot table

Hello,
In Excel 97, I used record macro feature to create a
pivot table and it defined SourceData:= "20040608!
R1C1:R4C3") in the pivot table definition. Here 20040608
is the first sheet name and R1C1:R4C3 is the range for
the data. Each time when I run the macro these data would
be different, how can I figure out them and use as
SourceData in the pivot table.
Thanks,
Jim.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Pivot table with a variable range in the sourcedata field	[email protected]	Excel Discussion (Misc queries)	2	January 31st 07 12:11 AM
Reling Pivot sourcedata to network drive	MattShoreson[_13_]	Excel Programming	0	May 4th 04 01:38 PM
Change SourceData in Excel PivotTable via VBA	CarlsonClan	Excel Programming	1	April 9th 04 04:15 AM
Setting up a SourceData:= in VB	Emmanuel[_2_]	Excel Programming	1	January 22nd 04 08:15 PM
Dynamic Array as pivot table SourceData..?	Robert Stober	Excel Programming	0	October 3rd 03 05:36 PM

All times are GMT +1. The time now is 06:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us