In VB how can I detect which sheets are selected? If a single sheet were selected, then "selection.address (external:=true)" would be one way to do it. But if the user has selected multiple sheets, or if a preceeding VBA function has done something like
"Sheets(Array("Sheet2", "Sheet1")).Select",
then what?
"Sheets(Array("Sheet2", "Sheet1")).Select",
then what?