View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bettergains Bettergains is offline
external usenet poster
 
Posts: 33
Default 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.