Macro to hide rows.
The document is a fax form.
-----Original Message-----
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.
.
|