Jump to content
Sign in to follow this  
foray

excel udf group function?!

Recommended Posts

foray

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
SimonWebstation

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
foray

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
picaxe

; 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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.