View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Perry Kew Perry Kew is offline
external usenet poster
 
Posts: 3
Default Deleting rows filled with 0

In Excel 2002 I have a sheet with data table from A1:E9.

The actual starts at B2 and ends at E9. If B:E of the same
row has zero I would like to delete that row. Thus if
cells in the range B3:E3 and cells in the range B8:E8 have
zeros then those rows should be deleted.

Thanks.