View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GJR3599 GJR3599 is offline
external usenet poster
 
Posts: 4
Default Hiding blank rows using a macro

How do I write a macro that will hide rows that contain all zeroes in a
certain field. For example, if columns B:N are blank for rows 5-8 contain
only zeroes, how do I tell the macro to hide these rows IF those columns are
blank? Preferrably I'd like this to work for the whole worksheet. Thanks!