Posted to microsoft.public.excel.programming

OJ[_2_]

external usenet poster

Posts: 111

Excel vba pivot table programming

Hi,
How about using a dynamic range name for the source of the pivot
table...

something like..

=offset(Sheet1!$A$1,0,0,counta($A:$A),Counta($1:$1 ))
Hth,
Oli

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 to create pivot table from existing pivot table in excel 2007	Udayraj Dhulekar	Excel Discussion (Misc queries)	2	July 8th 13 08:22 PM
Excel Food Price Table, Programming, Is This Table All Right?	Davi	Excel Discussion (Misc queries)	2	June 3rd 07 12:24 PM
Pivot Table Programming	Marvin	Excel Programming	1	January 25th 05 10:54 PM
Pivot Table Programming	OrrLyfe	Excel Programming	3	November 1st 04 12:44 AM
Pivot table Programming	Kris	Excel Programming	1	October 5th 04 09:03 PM

All times are GMT +1. The time now is 02:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us