Using For loop to condition

Is it ok to use a For loop to look to condition? I'm trying to loop over a range for something like this

For prodcntr = 24 To Cells(1, 1).FindFormat.Interior.Pattern = xlGray25
If Worksheets("Schedule").Cells(prodcntr, 2) <> "" And Worksheets("Schedule").Cells(prodcntr, 2) > 0 Then
prodlgnth = prodlgnth + 1

End If

Next prodcntr

I'm trying to make the range for the loop more dynamic.

A For-Next loop is intended to start at one numeric value and end at another,
either incrementing or decrementing by a numeric value. Examples:

For i = 1 To 10
Next i

For i = 10 To 1 Step -1
Next i

For i = iStart To iEnd Step 2
Next i

etc.

but you can test for a condition inside the loop and exit like this:

For i = 24 To Whatever
If Cells(i, 1).FindFormat.Interior.Pattern = xlGray2 Then Exit For
Next i


"bundyloco" wrote:

>
> Is it ok to use a For loop to look to condition? I'm trying to loop over
> a range for something like this
>
> For prodcntr = 24 To Cells(1, 1).FindFormat.Interior.Pattern =
> xlGray25
> If Worksheets("Schedule").Cells(prodcntr, 2) <> "" And
> Worksheets("Schedule").Cells(prodcntr, 2) > 0 Then
> prodlgnth = prodlgnth + 1
>
> End If
>
> Next prodcntr
>
> I'm trying to make the range for the loop more dynamic.
>
>
> --
> bundyloco
> ------------------------------------------------------------------------
> bundyloco's Profile: http://www.excelforum.com/member.php...o&userid=23386
> View this thread: http://www.excelforum.com/showthread...hreadid=397292
>
>