excel udf group function?!

[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

[foray]

:push: no one?

[SimonWebstation]

can you more accurately describe that

[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!

[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

[foray]

thanks alot!!!!