Selection.worksheets
 

I found that the code in the title is not correct. I want to operate on each
worksheet in the selected worksheets.
I tried:
for each wksht in selection.worksheets
code
next wksht
What code should I use?

--
David

Selection.worksheets
 

Something like this might work ok:

Dim wks As Worksheet
For Each wks In ActiveWindow.SelectedSheets
MsgBox wks.Name
Next wks



David wrote:

I found that the code in the title is not correct. I want to operate on each
worksheet in the selected worksheets.
I tried:
for each wksht in selection.worksheets
code
next wksht
What code should I use?

--
David

--

Dave Peterson

Selection.worksheets
 

Thanks David
--
David