Thread: For next
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default For next

You can put the numbers in a range of cells, or in an array.
An array would go somethin like this.

Dim x As Variant
x = Array(4, 10, 19, 27)
For i = LBound(x) To UBound(x)
If x(i) = "something" Then
'Do something
End If
Next

"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.