For next
 

Use an array if there is no sequence ...

arrLoop = Array(4, 10, 19, 27)
For intTemp = 0 To UBound(arrLoop)
x = arrLoop(intTemp)
MsgBox x
Next



If this post helps click Yes
---------------
Jacob Skaria


"Mike" wrote:

Is there a way to write a for next statement for some set numbers.

For instance, I want to have a loop to run for x = 4, 10, 19, 27.

Thanks,
Mike.