Jump to content

excel udf group function?!


foray
 Share

Recommended Posts

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

Link to comment
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

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...