Hi David

You can loop through them like this

Sub test()
Dim sh As Worksheet
For Each sh In ActiveWindow.SelectedSheets
MsgBox sh.Name
Next
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"DavidMatthews" wrote in message
...
Hi,

I'm trying to create a macro that will only affect the worksheets that are currently selected (when a user uses ctrl+click on
multiple worksheet tabs). How do I identify which worksheets are selected in VBA?

Thank you very much,
-David