That's what I'm looking for, thanks Kris and Don!
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not b
-Macros$$ Re: Syntax request: the array that holds grouped tabs
Hi
Sub kTest()
Dim i As Long, c As Long, ShtAs String
With ActiveWindow
c = .SelectedSheets.Count
If c Then
For i = 1 To c
Sht = Sht & vbLf & .SelectedSheets
Hi
Sub kTest()
Dim i As Long, c As Long, ShtAs String
With ActiveWindow
c = .SelectedSheets.Count
If c Then
For i = 1 To c
Sht = Sht & vbLf & .SelectedSheets(i).Name
Next
MsgBox "The following Sheet(s) ar
Continuation:
What I'm hoping to find is a specific way to learn which worksheets
have been grouped. I'm happy to build my own array: is there a boolean
that indicates whether a given sheet is selected? Maybe something
like...
dim TabName as worksheet
For each TabName in Sheets
if TabName.Select