Pivot in a Macro

[KrisBeau]

I am a macro Newbie. I am trying to create a macro that creates a pivot, I get an error at this step:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"170_DESC_RECON_DATA!R2C1:R3068C9", Version:=xlPivotTableVersion12). _
CreatePivotTable TableDestination:="Sheet9!R3C1", TableName:="PivotTable1" _
, DefaultVersion:=xlPivotTableVersion12

any ideas?

Many thanks!