ExcelBanter - Using VBA to change a Column heading in a pivot to a cell referenc

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using VBA to change a Column heading in a pivot to a cell referenc (https://www.excelbanter.com/excel-programming/348937-using-vba-change-column-heading-pivot-cell-referenc.html)

Andre

Using VBA to change a Column heading in a pivot to a cell referenc

Hi,
I need help in creating VBA code to change the headings of a pivot table
column after it has been created to a cell referance that is in the same
workbook. Example: Change the heading of column 1(Period01) in pivot
table1(sheet2) to cell A20(January) in sheet1.

Hope someone can help me.
Andre

All times are GMT +1. The time now is 07:43 PM.