Thanks Tom, sorry for the poor explanation.
But I think you had the right approach last time. What I want to do i
check to see if AO = x, if it does continue. If not got to the nex
cell in the range AK:AP on the same row.

Is that what the Intersect code is for?

Thanks again

I also agree with you on my whole approach, I guess a case statemen
would be more appropriate

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