Hello all
when you use
ActiveCell.Rows("1:60").EntireRow.Select
Selection.Rows.group
works fine,
Now in the Excel mode, there is a (-) {for grouping} just besides the colmun that holds the numbers of the sheet rows, so when you hit it then the group of rows is hiden........
i tried several time writing a code does this job, but................
even this code (Selection.Rows.Ungroup) does not hide the rows
appreciate any hints
yours
hesham