Turn on the macro recorder, then collapse the rows. Turn off the macro
recorder, and you should have your code.

--
Regards,
Tom Ogilvy

"Jesterhoz" wrote in message
...
Hello All,

I have a macro that has run and created multiple subtotals. At the end, I
would like the macro to collapse all of the subtotal ranges so that the
user
will see just the summary subtotal data. Does anyone have any ideas on
how
to accomplish this?

Thanks,

Trevor