Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default Outline Object

Hi.

I'm using the subtotal method of the range object to create subtotals.

This method appears to either create or at least update the Outline object
of the worksheet.

The user would like to have a blank row above and below her subtotals which
are created using the subtotal method. When these are inserted, they are not
included in the groupings created by the subtotal method, so when you ask the
spreadsheet to display the outline at rowlevels:=2, it still shows the blank
lines.

I've looked in the help, and don't see much about how the Outline is
created, or how to manipulate it in code.

If Rows 31 to 40 are in a single group, is there a way to insert a new row
above the current row 31 which is still grouped in the group that was row 31
to 40?

Thanks.
Mark
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
2 Label Options - Forms Object vs Control Box Object Awrex Excel Discussion (Misc queries) 3 July 17th 09 07:10 PM
Object Variable Not Set Error on Selection object Jean Excel Worksheet Functions 3 July 24th 06 06:45 PM
Option button object proeprties or object not found in vba Pete Straman S via OfficeKB.com Excel Programming 0 August 31st 05 05:49 PM
Confusion about how the Window object fits into the Excel object model Josh Sale Excel Programming 11 April 15th 05 06:08 PM
returning pivottable object from a range object Grant Excel Programming 2 September 27th 04 02:22 AM


All times are GMT +1. The time now is 05:34 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"