View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Removing Rows for Printing

If you want an alternative approach, you could set up a filter to cover
column A only. Then when you are ready to print you use the filter to
select Custom ... | Not Equal To | 0 (zero).

In this way only the rows with non-zero values will be displayed (and
printed).

Hope this helps.

Pete