View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob[_64_] Bob[_64_] is offline
external usenet poster
 
Posts: 1
Default PivotTable ColumnFields AutoSelection

Hi all,

When programming using VBA to create PivotTable, in its Page Field we
can use "CurrentPage" to Set/Get the current page showing for the page
field. Of course this works for Page field only.

My question is, is there a similar property/method ("CurrentColumn"??)
available in ColumnFields so I can Set/Get the current column field
showing for the column field.

Many thanks to you all

Kind Regards,

Bob