Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving through sheets
I want to run a routine on each sheet in the workbook. As
the numberf of sheets may change, I would prefer not to refer to them by name. Can anyone advise on the With/End With or For / Next code into which I can put my routine? So far I have got Sub UpdateFalseNew() Dim wrkBook As Workbook Dim wrkSht As Sheets wrkBook = ThisWorkbook For Each wrkSht In wrkBook wrkSht.Select setupdatefalse Next wrkSht End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Moving Between Sheets | Excel Discussion (Misc queries) | |||
Moving through sheets | Excel Discussion (Misc queries) | |||
moving between sheets | Excel Programming | |||
Moving data to sheets | Excel Programming |