Turn the macro recorder on, select column C, DataFilter, select the
dropdown at the head of the column, and choose NonBlanks, stop the macro
recorder.

That's it, you have your macro.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tp58tp" wrote in message
...
I have a spreadsheet to reflect daily production. In columns A and B
there
is a complete listing of all product codes and descriptions. Column C is
the
particular day's production. When I normally prepare this for
distribution I
manually hide the rows of products which had no production for that day -
to
make a short, concise report. How can I create a macro to auomatically do
this?