I got it!

I just kept playing around with combinations of your posts and and I
came up with this:

For x = 11 To 298
counter = 0
If .Cells(x, skilly).Value = "x" Then
For y = timeStart To timeStart + 7
If .Cells(x, y).Value = "." _
And .Cells(x, y).Offset(0, 31) = "." _
And need 0 Then
..Cells(x, y).Offset(0, 0).Resize(1, 32).Value = "MMS"

need = need - 8

End If
Next y
End If
Next x

Thanks Tom ,you are the best!


---
Message posted from http://www.ExcelForum.com/