Much Closer, Thanks Leo!

But this is what is happening that should not. As the code reaches the
end of the range for each row it should drop one row and start from the
begining of the range. Right now it is dropping down but it is starting
from where the last row ended.

It also increments to the next value, even though that value does not =
2 in the next row.

I'll attach the file

Attachment filename: copy of hotherps72.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=560768
---
Message posted from http://www.ExcelForum.com/