View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moonhk moonhk is offline
external usenet poster
 
Posts: 62
Default How to ungroup ?

Hi Reader
Do you know how to ungroup row ? My Workbook have 4 worksheet,each
worksheet have been groupd how to ungroup row using VBA ?

I try below coding , just ungroup one group.
Worksheets("SH-451455").Activate
Set myRange = ActiveCell.CurrentRegion
lastRow = myRange.Rows.Count
myRange.Rows(lastRow).ShowDetail = True

Moonhk