Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Question
I'm trying to loop through a workbook, test to see if the worksheet name is
numeric, and if so go to a subroutine(MoveData), if not, continue to the next worksheet. I tried the following but can't get it to work, it has a problem with the Next line. Anyone have any ideas? Thanks, Alan Sub Move_All_Data() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Select If IsNumeric(ActiveSheet.Name) Then MoveData Else Next ws End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop question | Excel Discussion (Misc queries) | |||
end with loop question | Excel Programming | |||
loop question | Excel Programming | |||
One more loop question | Excel Programming | |||
another loop question | Excel Programming |