HI Tom, Thanks so much for your help. I had to change a few things t
get the code to run, and it seems to be running fine, the Intersec
statement is working also.

One part of the functionality changed though:

It is disregarding the = and <= in each row. If there is an "x" ou
between AK:AP it starts to fill the you even though the = or <= ha
already been met.

Don't understand why it stopped working

Thanks agai

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