sounds like you need toconstruct your conditions in an

if conditions then


Elseif conditions then



elseif conditions then


Else

End if

Rather than
if conditions then

End if
if conditions then

End if
if conditions then

End if

--
Regards,
Tom Ogilvy

"hotherps " wrote in message
...
HI Tom, Thanks so much for your help. I had to change a few things to
get the code to run, and it seems to be running fine, the Intersect
statement is working also.

One part of the functionality changed though:

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

Don't understand why it stopped working

Thanks again


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