Is there data filtering on the sheet? Are the row heights set to 0?

Does it work for you if you try it in a new workbook? Just that macro,
nothing else. It works for me.

--
Tim Zych
SF, CA

wrote in message
...
On Dec 12, 12:30 pm, ward376 wrote:
Maybe what's being entered in the cell isn't exactly the text in the
code? It's case-sensitive; "yes" or "Yes" won't make it work... even
leading or trailing spaces won't.

To both the above, thanks for the resposes and yes, I was expecting
the code to do exactly as it looks, hide and unhide the rows based on
the cell values but for the life of me (and the other IT consultants
sitting next to me) we cannot figure out why this does not work. The
cell values are correct, they are selected from a cell validation drop
down box and when stepping thru the macro, the correct commands are
being called. It still doesn't work. There is (obviously) something
else affecting the code, the cells, the whatever but I cannot find it!
gavin