Grouping data in Excel 2007

See more:

C#

Hi. I have a problem in grouping data in excel using C#. I can only manage to group the first table. I have about 5 tables, repeated ones. I need to have those same tables having group the same data. Here's the code that i used:

objSheet.get_Range("A" + m_EndOfRow.ToString(), Type.Missing).get_Offset(1, 0).EntireRow.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);

and this:

Excel.Range myrange = objSheet.Rows["2:6", Type.Missing] as Excel.Range;
myrange.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);

Please advise. Thanks in advance.