Excel Range.OutlineLevel problem   

I am looping through a set of data and building an excel spreadsheet.  I am 
grouping data using the group method.  Below is an example:

//group sub topic items
groupRange = wsheet.Rows[string.Format("{0}:{1}", groupStartLevel2, 
excelRowTracker-1), Type.Missing] as Excel.Range;
groupRange.OutlineLevel = 2;
groupRange.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);

On the line where I set OutlineLevel=2 (or if I set OutlineLevel=1) there is 
an audible "ding" as though there was some bad action.  Does anyone have any 
idea why the computer is "dinging" at me when I set OutlineLevel?

date: Wed, 19 Dec 2007 22:20:00 -0800   author:   Todd Miranda

Re: Excel Range.OutlineLevel problem   

I think you must set outline levels on EntireRow (or is it WholeRow?) - pick 
any cell on the row, then get the row object from teh cell and finally apply 
your outline level.

HTH

-- 
Julian I-Do-Stuff

Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
"Todd Miranda"  wrote in message 
news:CD66EF04-E233-4244-A259-56B09E92A94A@microsoft.com...
>I am looping through a set of data and building an excel spreadsheet.  I am
> grouping data using the group method.  Below is an example:
>
> //group sub topic items
> groupRange = wsheet.Rows[string.Format("{0}:{1}", groupStartLevel2,
> excelRowTracker-1), Type.Missing] as Excel.Range;
> groupRange.OutlineLevel = 2;
> groupRange.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
>
> On the line where I set OutlineLevel=2 (or if I set OutlineLevel=1) there 
> is
> an audible "ding" as though there was some bad action.  Does anyone have 
> any
> idea why the computer is "dinging" at me when I set OutlineLevel?

date: Fri, 11 Jan 2008 18:52:35 +0100   author:   Julian