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