Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping only through selected sheets
"Mike H" wrote: Hi, Try this Dim sh As Object For Each sh In ActiveWindow.SelectedSheets MsgBox sh.Name 'do things Next Mike "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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 Worksheet Functions | |||
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 |