LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Grouping rows in Excel with the plus/minus icon in the first row


Basically the title says it. I'm grouping rows using a statement like this:

sheet.Range("A2", "A10").Rows.Group()

This works perfectly, but the problem is that the plus/minus button is below
the group in row 11, but I need it to be in row 1.
I realize that it makes sense to have it below the rows if you want to hide
the components of a sum, but I'm want to use the groups for hiding lower
members of a hierarchy. I attached 2 screenshots for illustration.

#1: Expanded hierarchy, note the minus below, not above the group:
http://img31.imageshack.us/img31/1128/hiexpanded.jpg
#2: Collapsed hierarchy, with the plus in the wrong row:
http://img221.imageshack.us/img221/6779/hicollapsed.jpg

Is there a way to do this? I already spent hours on google but didn't find
anything.

I'm using Excel 2007 and VS2008 SP1, the project is an application level
add-in.


Thanks a lot for your answers and thoughts on this.
 
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
How to get the plus/minus at the top when grouping beac Excel Worksheet Functions 4 April 19th 23 02:14 PM
Grouping Rows in Excel 2007 Philip J Smith Excel Discussion (Misc queries) 2 December 12th 08 12:25 PM
Excel grouping then inserting rows and summing up.... [email protected][_2_] Excel Programming 4 May 30th 07 06:45 PM
Error in grouping rows in excel using VB [email protected] Excel Programming 0 December 5th 06 06:03 PM
sum and minus columns and rows at the same time MARY Charts and Charting in Excel 0 February 7th 06 08:43 PM


All times are GMT +1. The time now is 12:54 PM.

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"