Dynamic range

[Jolenelity]

Hi, just one more question... For this codes: The one which is highlighted in red, how can I make it to dynamic range too?

Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Residential Raw!R1C1:R659C34", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable6" _
, DefaultVersion:=xlPivotTableVersion14

Thank you!

 

[VoG]

Please stick to your original thread http://www.mrexcel.com/forum/excel-questions/707582-range-into-dynamic.html