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