View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.



.