I want to paste a new pivot table under an existing one, Thing is, I dont know how long the initial pivot table will be. I considered using an lLastRow Dim but it did not work, any suggestions???

Thanks in advance.

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Active Only, No PSG, Yes IGR!R1C1:R" & lLastRow & "C" & lLastColumn, Version:=xlPivotTableVersion12 _
).CreatePivotTable TableDestination:="PivotTable!R2C2", TableName:= _
"PivotTable3", DefaultVersion:=xlPivotTableVersion12
Sheets("PivotTable").Select

'Region Selection

Cells(2, 2).Select