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:=xlConsolidation,
SourceData:= _
Array("'EAG Original'!R1C2:R82C6")).CreatePivotTable
TableDestination:="", _
TableName:="PivotTable15"


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