pivotitem.visible appears as integer during debugging.true, false
cannot be configured.excel VBA 2010
I found something that seems to be an answer on an overseas site.
Please forgive me for writing without quoting.Thank you.
Occurs when the data specified in pivotfield is in date format.
This seems to be especially true for non-US locales.
A column of another name is created to convert the target data into data of a character string yyyy/mm/dd.
Use the alias pivotfield you created.
You will be able to set true and false to pivotem.visible.
The part where pivot.visible appears in the IDE does not change.
© 2024 OneMinuteCode. All rights reserved.