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