Which sheets are selected?

[DOBrown]

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?

 

[Colo]

Hi DOBrown,
Selection.Address returns the value of *Activesheet*.
Multiple sheets are can be selected, but there is only one Activesheet.

<pre>
Sub test()
Dim wsSelected As Sheets, ws As Worksheet
Set wsSelected = ActiveWindow.SelectedSheets
For Each ws In wsSelected
Debug.Print ws.Name
Debug.Print ActiveSheet.Name = ws.Name
Debug.Print Selection.Address(external:=True); ""
Next
End Sub
</pre>

 

[DOBrown]

Colo-

Excellent! I was looking in all the wrong places.

Thanks,
DB