I believe that Mark F's suggestion only works in excel 07
Not sure whether you mean manually or via code
If manually, Highlight all of the rows you want in a group, the do Data, Group and Outline, Group
Apologies if this isn't what you need
Mark![]()
I get the same message,' the command you chose can not be used with multiple sections'.
im using excel xp sp2 (2003)
Sub hiderows()
If Range("1:3,20:23").EntireRow.Hidden = False Then
Range("1:3,20:23").EntireRow.Hidden = True
Else: Range("1:3,20:23").EntireRow.Hidden = False
End If
End Sub
Sub hidecolumns()
If Range("A:C,T:V").EntireColumn.Hidden = False Then
Range("A:C,T:V").EntireColumn.Hidden = True
Else: Range("A:C,T:V").EntireColumn.Hidden = False
End If
End Sub