Hi Steve

I would use Filter / Autofilter for this (goto "Data - Filter") and
filter all 'non blanks#

HTH
Frank

Steve wrote:
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.