View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Macro for hiding zero data rows while printing

I want to print an Excel report where rows are accounts and columns are
periods, and the data is in dollars. The report should not print out all
those rows that have zero data in them. Can a macro or a combination of some
Excel function & macro do that? How?