You can write something like:
If activecell = <your parameters then Selection.EntireRow.Hidden =
True
Tim
--
TimZ
------------------------------------------------------------------------
TimZ's Profile:
http://www.excelforum.com/member.php...o&userid=23558
View this thread:
http://www.excelforum.com/showthread...hreadid=373865