| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to skip some sheets in workbook
What do I put where it says 'DO NOTHING so the loop will skip ws. X, Y & Z? Thanks, Howard Option Explicit Sub LoopThroughSheets() Dim ws As Worksheet If ws.Name = "X" Or ws.Name = "Y" Or ws.Name = "Z" Then 'DO NOTHING Else 'Do some code stuff here like: ws.Range("B1") = ws.Name End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop several sheets - not all worksheets of workbook | Excel Programming | |||
| Master's please help me with my code; Doing a loop to copy valuesfrom a series Sheets of another workbook.. | Excel Programming | |||
| apply Macro to all sheets in workbook - loop | Excel Programming | |||
| Skip LOC in D While Loop | Excel Programming | |||
| Loop through all sheets in workbook | Excel Programming | |||
Threaded Mode
