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. copy the contents from A1 Paste them into B1 copy cell C1 (it has a simple formula that acts on B1) copy the value (only) from C1 into D1 (.1 answer Top answer: Your want a simple For.Next loop:Sub PasteSpecialExamples()For i 1 To 1000Range(A & i).Copy Range(B1)Range(C1).CopyRange(D & i).PasteSpecial.

This step allows you to initialize any loop control variables and increment the step counter variable. This is what I think you are looking to accomplish. Following is the flow of control in a For Loop. 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. 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. 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. Press Alt + F11 keys to enable the Microsoft Visual Basic for Applications window. 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. arrow blue right bubble Loop through rows until blank with VBA 1.

Visual basic for excel for loop