PDA

View Full Version : Detecting Multiple Active Sheets



MWE
07-02-2013, 01:12 PM
It is quite easy to manually select multiple sheets. It is also quite easy to do this in VBA using an array statement, for example
Worksheets(Array("A","B")).Select But assuming that multiple sheets have been selected manually, how do you determine that in VBA?

SamT
07-02-2013, 02:01 PM
Excel.Windows(1).SelectedSheets.Count