What do you want to do with the rows that are left visible. Do you want to
print them? Copy them? Just look at them? HTH Otto
"Steve" wrote in message
...
I have a stock order form. I want to find a way to hide
rows containg items that do not need to be ordered. for
example:

A B
1 paper 2
2 ink
3 pens 4
4 staples

Is there a macro that can filter out empty quantity celss
and hide the whole row (rows 2 and 4 in this instance)?
I appreciate your time and effort.
Steve.