Electricbluelady,

Select the cells with the values (including the header row), then use Data / Filters....
AutoFilter. Select the dropdown on the header cell, then choose Custom, Does Not Equal, and enter a
0 into the right hand box. Press OK and you are done.

HTH,
Bernie
MS Excel MVP


"electricbluelady" wrote in message
...
Hello,
I am working on invoices for my employer. Each row in the spreadsheet has a
calculated value. When the calculated value in the row = 0, then I am to
'hide' the row. If the calculated value is not =0, (could be positive or
negative), then I am to display or 'unhide' the row. Does anyone know how to
do this? Macros and VBA responses are ok. :)
--
Thank you,
Electricbluelady