View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DG DG is offline
external usenet poster
 
Posts: 46
Default Expand and Collapse groups

I have a range of rows (10 - 15) that are grouped.

Thus

Rows("10:15").Select

How do I collapse and expand the group in vba?

I tried to record the macro while I clicked the + and - signs but it
recorded nothing.

DG