Sign in to follow this  
Followers 0
foray

excel udf group function?!

6 posts in this topic

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

Share this post


Link to post
Share on other sites



can you more accurately describe that


mfg. SimonMany of my answers are translated of google, because I'am from Germany

Share this post


Link to post
Share on other sites

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!

Posted Image

Share this post


Link to post
Share on other sites

; 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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0