Nevermind Tom, my mistake again.

What I failed to tell you is that everytime 8 "IND"s are added the cod
drops down to the next row or further.

IND does not always meet the criteria of every row.

So now let me try to figure out how to integrate into my code tha
loops through the rows.

Oh by the way, I knew what you gave me would work so I copied IN
across a whole row, and it worked just as I'm sure you intended.

Thanks again

back to work..

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