Thread: Hiding rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dennis dennis is offline
external usenet poster
 
Posts: 202
Default Hiding rows

I am working in an Excel Report Generator (Excel 2000) setting up financial
statement templates. Is it possible to set a command or condition for each
row where if no data exists across several column cells (i.e. no activity in
current month or YearToDate or prior year's month or prior YTD), the row will
automatically be hidden when printing - row contains account description + 7
numeric cells, i.e. 8 columns? This is to avoid the printing of zero
accounts. Most accounting software with print set-ups offer this option.

Thanks