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
[vba]Worksheets(Array("A","B")).Select[/vba] But assuming that multiple sheets have been selected manually, how do you determine that in VBA?