Here is the code I am using.


If .Cells(x, y).Value = "." _
And counter < 6 _
And need2 0 Then
.Cells(x, y).Value = "Test"


Is there a way I can have the code look forward down the row to see i
it can be placed 6 times?

There are many reasons it could come up short, and I'm trying to avoi
having an incomplete row. I want the value to appear 6 times or not a
all.

I would prefer the code to just continue on through the rows until i
can add all 6 cells again.

Thank

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