foray Posted September 24, 2009 Share Posted September 24, 2009 hey there, i checked the integrated excel udf and the excelcom here in the forum, but it looks like no version supports a GROUP Command. Does someone know a workaround?! Thanks for help! Greets Link to comment Share on other sites More sharing options...
foray Posted September 26, 2009 Author Share Posted September 26, 2009 :push: no one? Link to comment Share on other sites More sharing options...
SimonWebstation Posted September 26, 2009 Share Posted September 26, 2009 can you more accurately describe that mfg. SimonMany of my answers are translated of google, because I'am from Germany Link to comment Share on other sites More sharing options...
foray Posted September 26, 2009 Author Share Posted September 26, 2009 i mean this function below. i have not realy an idea how to describe this function.you can group serveral rows/columns and group than, than you can expand them by clicking the plus symbol or hide them by click on minus button.THANKS! Link to comment Share on other sites More sharing options...
picaxe Posted September 26, 2009 Share Posted September 26, 2009 ; quick example with no error checking $oExcel = ObjCreate("Excel.Application") With $oExcel .Visible = True .WorkBooks.Add For $i = 1 To 10 For $k = 1 To 30 .Cells($k, $i).Value = Int(Random(1, 10000)) Next Next .Range("D5:F5").Select .Selection.Columns.Group .Range("D20:F28").Select .Selection.Rows.Group MsgBox(262144 +64, "UnGroup Rows", "Click to Ungroup rows" & @TAB) .Selection.Rows.Ungroup EndWith Link to comment Share on other sites More sharing options...
foray Posted September 27, 2009 Author Share Posted September 27, 2009 thanks alot!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now