$$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

2012-02-03 Thread Kris
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) are

Re: $$Excel-Macros$$ Re: Syntax request: the array that holds grouped tabs

2012-02-03 Thread dguillett1
-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(i).Name