Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes, you can do this with a macro:
sub ShowColumns()
set obj = ActiveDocument.GetSheetObject( "CH02" )
w = obj.GetColumnCount
msgbox(w)
end sub
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
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.
Hi,
ok i see, thank you.
Best Regards,
Emteam
Could you mark this as answered? That makes the answer easier to find for others with the same question. Thanks.