View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default Testing for and ungrouping grouped sheets

Vasant,

Thank you for your help,

Conan




"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
One possibility:

If ActiveWindow.SelectedSheets.Count 1 Then ActiveSheet.Select

Or just:

ActiveSheet.Select
__________________________________________________ ______________________



"Conan Kelly" wrote in message
...
Hello all,

(Using XL 2002)

How would I test for Grouped Sheets and then ungroup them if they are
grouped.

Thanks for any help anyone can provide,

Conan Kelly