I am trying to automate emailing of financial reports to managers in our
Organization. I have one spreadsheet template with every account listed.
However, not every manager has amount in every line, and the report is pretty
long with every account listed.

I would like to create a macro to look at the a range of values in each row
of the report, and then hide any rows which have a zero value in each cell in
the range.