ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PivotTable ColumnFields AutoSelection (https://www.excelbanter.com/excel-programming/320671-pivottable-columnfields-autoselection.html)

Bob[_64_]

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


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com