Column Number pivot table

[emteam162]

Hi,

I want know number of column the pivot table.

exist a function that allows to know the number column.

Many thanks for your help.

Best Regards,

Emteam

[Gysbert_Wassenaar]

yes, you can do this with a macro:

sub ShowColumns()

set obj = ActiveDocument.GetSheetObject( "CH02" )

w = obj.GetColumnCount

msgbox(w)

end sub

[#3]

Hi,

Thank you for reply.

My idea is when you make a selection in pivot table (mybe you can know the location clicked at the pivot table).

I can't implement ColumnNo()???

Can you attach Example with : Pivot Table and ColumnNo(),dimensionality()

Many thanks for your help.

Best Regards,

Emteam

[Gysbert_Wassenaar]

As far as I know there is no way to get the column and row of the cell of the pivot table when you click on the cell.

[emteam162]

Hi,

ok i see, thank you.

Best Regards,

Emteam

[Gysbert_Wassenaar]

Could you mark this as answered? That makes the answer easier to find for others with the same question. Thanks.