You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@aggi
A strange VBA issue. For some reason removing subtotals from a pivot table is far quicker when you click the button on the menu bar rather than using a macro to do it. This led me to discover that you can include menu items in VBA using
This one removes subtotals for instance and works fine. The ID came from https://www.microsoft.com/en-au/download/details.aspx?id=36798
However, when I try to run other commands they sometimes work and sometimes give this error
It's not vital to anything I'm doing, I'm just curious if anyone knows why this is. It doesn't seem to crop up on forums much.
1 Attachment