View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default automatically hide rows with zero value

Autofilter will allow you to hide rows where a cell contains zero
(select Custom | Not Equal To | and enter zero), but this will be
manual rather than automatic.

Hope this helps.

Pete