| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping only through selected sheets
Thanks. Did not think of using the Window object. Though it should be in
the Workbook object. "Paul S" wrote: What is the VBA code to loop through only the selected sheets in a workbook? That is if I have a workbook contain sheets A, B, C, D, and E and if I have selected multiple sheets, say A, B and E, how do I write code that will perform operations only on those sheets (A, B, and E)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping only through selected sheets
But you could have multiple windows into the same workbook. And each window
could have different sheets selected. What would you use? Paul S wrote: Thanks. Did not think of using the Window object. Though it should be in the Workbook object. "Paul S" wrote: What is the VBA code to loop through only the selected sheets in a workbook? That is if I have a workbook contain sheets A, B, C, D, and E and if I have selected multiple sheets, say A, B and E, how do I write code that will perform operations only on those sheets (A, B, and E)? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping only through selected sheets
You are right. Thank you very much for your help.
"Dave Peterson" wrote: But you could have multiple windows into the same workbook. And each window could have different sheets selected. What would you use? Paul S wrote: Thanks. Did not think of using the Window object. Though it should be in the Workbook object. "Paul S" wrote: What is the VBA code to loop through only the selected sheets in a workbook? That is if I have a workbook contain sheets A, B, C, D, and E and if I have selected multiple sheets, say A, B and E, how do I write code that will perform operations only on those sheets (A, B, and E)? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping only through selected sheets | Excel Programming | |||
| Looping through selected worksheets and delete a range (e.g., A2:D15) | Excel Programming | |||
| Looping through selected charts | Excel Programming | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
| looping through selected sheet tabs | Excel Programming | |||
Linear Mode
