| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection.worksheets
Thanks David
-- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple selection copy & paste across multi-worksheets | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Hiding worksheets based on user selection | Excel Worksheet Functions | |||
| Excel should have unhide all worksheets selection or button. | Excel Worksheet Functions | |||
| Disabling Selection of multiple worksheets | Excel Programming | |||
Linear Mode
