I'm trying to create a multi-consolidation range pivot table via
macro. Each time I run the macro the number of rows will be different
The macro is currently hardcoding the source data into a fixed rang
for column and row. See below.

How do I change this to allow for a variable row selection?

ActiveWorkbook.PivotCaches.Add(SourceType:=xlConso lidation
SourceData:= _
Array("'EAG Original'!R1C2:R82C6")).CreatePivotTabl
TableDestination:="", _
TableName:="PivotTable15

--
amarch0
-----------------------------------------------------------------------
amarch00's Profile: http://www.officehelp.in/member.php?userid=1
View this thread: http://www.officehelp.in/showthread.php?t=63290
Visit - http://www.officehelp.in/archive/index.php

You could use a dynamic range as the pivot source, and refer to the
range name in the code. There are instructions he

http://www.contextures.com/xlPivot01.html


amarch00 wrote:
I'm trying to create a multi-consolidation range pivot table via a
macro. Each time I run the macro the number of rows will be different.
The macro is currently hardcoding the source data into a fixed range
for column and row. See below.

How do I change this to allow for a variable row selection?

ActiveWorkbook.PivotCaches.Add(SourceType:=xlConso lidation,
SourceData:= _
Array("'EAG Original'!R1C2:R82C6")).CreatePivotTable
TableDestination:="", _
TableName:="PivotTable15"




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html