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

Here is an idea for you. In your code put a sum formula that would add the
values of that specific row. Then, if the value of the sum is 0 then hide
entirerow.

Hope that helps


"Dennis" wrote:

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