Grouping Cells with Macro
 

Hi,

My spreadsheet currently uses datagroup to group items under differen
headings. I would like to create a toggle to expand and contract al
groups but when I try to record a macro, none of the grouping action
get recorded. Please help me out.

Thanks.

Ja

--
Jay63
-----------------------------------------------------------------------
Jay637's Profile: http://www.excelforum.com/member.php...fo&userid=2544
View this thread: http://www.excelforum.com/showthread.php?threadid=38892

Grouping Cells with Macro
 

http://tinyurl.com/a28mz

Should find an answer and sample code there.

--
Regards,
Tom Ogilvy

"Jay637" wrote in
message ...

Hi,

My spreadsheet currently uses datagroup to group items under different
headings. I would like to create a toggle to expand and contract all
groups but when I try to record a macro, none of the grouping actions
get recorded. Please help me out.

Thanks.

Jay


--
Jay637
------------------------------------------------------------------------
Jay637's Profile:
http://www.excelforum.com/member.php...o&userid=25445
View this thread: http://www.excelforum.com/showthread...hreadid=388926