View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andre Andre is offline
external usenet poster
 
Posts: 31
Default 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