ExcelBanter - PivotLines collection

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

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

- - PivotLines collection (https://www.excelbanter.com/excel-programming/432582-pivotlines-collection.html)

MikeT

PivotLines collection

How do I use the PivotLines object? I thought it should be a property of a
pivot table, but when I use

ActiveSheet.PivotTables(1).PivotLines

I get "Object does not support this property or method"

ActiveSheet.PivotTables(1).Version = 3 (xlPivotTableVersion 12), so
shouldn;t my pivot table have the PivotLines property?

All times are GMT +1. The time now is 11:40 PM.