View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Gardill Joe Gardill is offline
external usenet poster
 
Posts: 1
Default Code for Excel 2007 to hide rows based on sum of several rows not ina range

I have a financial summary and depending on the selections some rows are
always going to have $0 values.

I need VBA code that will automatically run each time the worksheet
recalculates that will hide a row with all $0 values in columns B through F.
It affects a total of five rows and they all operate on different
conditions, but the rule would apply to all of them if the sum of columns B
through F for the row = $0.

Any help would be appreciated. I am only starting to work with code and have
never taken any courses so if you would not mind I would get a lot more out
of it with a simple explanation of how it works or a reference to review it.

Thank you in advance.

Joe
Frustrated in Baltimore