ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hide detail / close group outline (https://www.excelbanter.com/excel-programming/323553-hide-detail-close-group-outline.html)

Bettergains

hide detail / close group outline
 
Hello:
I have a macro that adds group outlines to columns. I tried to record the
closing of these outlined groups, but this results in something akin to:

Excel4macro [FUNCTION] that uses R1C1 column references and many commas

When the big macro is run, when it gets to this part, it chokes and I get an
error akin to "Your macro has too many arguments"). I realize I can simply
hide these columns--but would really like to see what the code is, if any for
"Hide all Detail". Does it exist for Excel 2003? Do I need an additional
reference? The rest of the code works well and I have multi add-ins /
references checked already.


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com