Is there a way to create a loop that takes only one step at a time and then waits for another trigger to proceed to the next increment in the loop? For example:
Range("$A4:$A50")
If I want to loop through the above range one cell at a time, do some stuff with the value in cell A4, then when I get ready to do stuff with the value in cell A5, I could trigger the loop to proceed to getting the value from that cell, etc., etc., until I get to cell A50, then start over at A4.