You can't, the closest you would get would be to use a filter, otherwise you
would need VBA
There is another way using conditional formatting but it will still print
that row albeit with invisible
text
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon