I am using Visual Studio 2008 to automate some tasks in Excel 2007. I have got most of what I need to do working but I am having difficulty getting the "Group" function to work. This is where you can select some rows and then click the "Group" option in the Outline part of the Data tab on the ribbon.
Is it possible to do this?
Any help greatly appreciated.