using 2003.

Columns("F:H").Select
Selection.Columns.group
will group the colums so the user can easily hide/unhide
the columns
Columns("F:H").Select
Selection.Columns.ungroup
will ungroup the columns ONLY if the columns are
grouped. if the columns are not grouped and the "ungroup" command is
issued, an error results.

question - is there a way to capture the "grouped" status of a
spreadsheet?

meg99