Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grouping cells johnrb7865 Excel Worksheet Functions 3 July 22nd 08 03:11 PM
grouping inside a macro deepika :excel help[_2_] Excel Discussion (Misc queries) 1 February 20th 08 08:46 AM
Grouping two cells together [email protected] Excel Discussion (Misc queries) 2 June 11th 07 03:58 PM
Grouping cells Michael Blogg Excel Discussion (Misc queries) 2 May 25th 05 12:18 PM
Grouping Cells Jenuine_2000 Excel Programming 0 October 4th 04 05:53 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"