This is what I think you are looking to accomplish. Next ws '(**This where I need the loop to stop after the last worksheet**)ī.Value = dtDate + TimeSerial(intHours, 0, 0)ī.Value = dtDate + TimeSerial(intHours, intMinutes, 0) 'check the index of the worksheet and exit if it is 6 It may be better to explain what you are trying to accomplish over all so you get a better response. If it is false, the body of the loop does not execute and the flow of. If it is true, the body of the loop is executed.

This step allows you to initialize any loop control variables and increment the step counter variable. Next K Next J Next I Note If you omit counter in a Next statement, execution continues as if counter is included. The following construction is correct: VB Copy For I 1 To 10 For J 1 To 10 For K 1 To 10. Give each loop a unique variable name as its counter. repeat the same piece of code) multiple times, this can.

On a side note, your first FOR loop is out of the scope of the second FOR loop so you are just setting the range over and over and doing nothing with it until the first FOR loop quits. Following is the flow of control in a For Loop. You can nest For.Next loops by placing one For.Next loop within another. If, in your VBA program, you need to perform the same task (i.e. In regards to your comments you need to change this to the on workbook open method to only run it once when the workbookis opened. Per your question you just need to check the worksheet index to see if it is 6 and if so then exit the for loop.

Visual basic for excel for loop