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

For prodcntr = 24 To Cells(1, 1).FindFormat.Interior.Pattern
xlGray25
If Worksheets("Schedule").Cells(prodcntr, 2) < "" An
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

--
bundyloc
-----------------------------------------------------------------------
bundyloco's Profile: http://www.excelforum.com/member.php...fo&userid=2338
View this thread: http://www.excelforum.com/showthread.php?threadid=39729