Pivot Help in VBA. Change coloumn Field Name to an Absolute

[cprince]

Hi All,

is there anyway I can change the below coloumn field name to an absolute coloumn. ?

So from this.

ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Slot", _
ColumnFields:="Nov Slot"

To something like this.

ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="Slot", _
ColumnFields:=Range("Z:Z")

Thanks