selecting variable rows in a macro that creates a pivot table

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/

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

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


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