Selection.worksheets

[David]

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]

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

[David]

Thanks David
--
David