Let me try to attach the file again Tom so you can see it.

Yes I do want the cell to read "PPI" if all available PACKS - QA - an
ICE are filled. But when I run the code i have values in the cells lik
"PAPPI" If it is out of the range it should read just "PPI"

Thank

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