Pivot table code

[bvwalker1]

I have a pivot table and I am stepping through the categories using the below code... From my understanding, objPivotItem is an object that has properties like name for instance. However, if I display just objPivotItem without the property .Name, I still get the same value. Why is this?

Please Login or Register  to view this content.

[MarvinP]

Hi,

I'd bet that .Name is the default property for that object. An example is that you can code a Cell.Value is the same as Cell but you might also want Cell.Address which isn't the default.

To resolve this question, I'd View my Object Browser and search the Excel functions for PivotItem, PivotFields, etc and see what the possible other properties are. Then in the immediate window I'd try to debug.print those items to see what VBA thinks they are.

Hope this helps.

[bvwalker1]

Hi,

I'd bet that .Name is the default property for that object. An example is that you can code a Cell.Value is the same as Cell but you might also want Cell.Address which isn't the default.

To resolve this question, I'd View my Object Browser and search the Excel functions for PivotItem, PivotFields, etc and see what the possible other properties are. Then in the immediate window I'd try to debug.print those items to see what VBA thinks they are.

Hope this helps.

Thanks MarvinP!