Posted to microsoft.public.excel.programming

Martin Los[_3_] Martin Los[_3_] is offline

external usenet poster

Posts: 22

Dynamic Pivot table range

Just trying to give an idea (not tried the code)

Maybe something like

Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, _
SourceData:=Activesheet.Range(Activesheet.Cells(co lumns.count,"IV").End(xlLeft))

could help?

Martin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Dynamic range in Pivot table	Wanna Learn	Excel Discussion (Misc queries)	4	July 2nd 07 08:08 PM
Using dynamic range to create pivot table	cursednomore	Excel Discussion (Misc queries)	5	March 12th 07 02:40 PM
Dynamic Range in a Pivot Table	Chris C	Excel Discussion (Misc queries)	0	June 27th 06 06:11 PM
Dynamic Range for Pivot Table	Rob	Excel Programming	1	June 20th 06 08:24 PM
Refreshing a Pivot Table from a dynamic range	matpj[_4_]	Excel Programming	2	October 20th 05 03:19 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us